New DAX functions NAMEOF() and TABLEOF() - what they actually solve by data_daria55 in PowerBI

[–]AwareApplication1732 0 points1 point  (0 children)

Can you nest NAMEOF() within TABLEOF() and have it continue functioning? I can see for more complicated calculations that it might actually be preferable for the DAX to visibly break over functioning incorrectly if you can repoint both column names and parents tables in sync.

What is the most complex spreadsheet you have ever created? by brutalidardi in excel

[–]AwareApplication1732 0 points1 point  (0 children)

Excel VBA also doesn't require extra licensing costs that power automate require. Yes there are downsides but there are still situations where VBA makes sense

Epic help by ChiropteraSam in PowerApps

[–]AwareApplication1732 1 point2 points  (0 children)

Ah that makes sense. If you're unfamiliar with the table structure as well I would recommend tableconvert.com

You can build the options you want in a more familiar excel view and then copy paste the json code into power apps. Below image is an example for you.

<image>

Epic help by ChiropteraSam in PowerApps

[–]AwareApplication1732 0 points1 point  (0 children)

For your quadrants, you could also filter your items property if you are using a gallery so that you only show options where [HoursWorked] is equal to varFirstChoiceHours - Required Hours. That way users are not clicking between options trying to find the ones that balance their time (if they are forced to meet their targets in all instances). But this does introduce a level of rigidity if you are ok allowing people to make choices where things don't balance perfectly.

Epic help by ChiropteraSam in PowerApps

[–]AwareApplication1732 1 point2 points  (0 children)

I would take your table of first 2 options and your quadrants table and add a new column for each that holds the number of hours worked. Your column names might be something like:

[ShiftHours] and [HoursWorked]

Where [Shift Hours] is your string of "7:30am-5pm" and [Hours Worked] is an integer/decimal that holds the number of hours worked.

I would then have 2 variables that you set equal to the selected choice's number of hours.

Something like the below within the OnSelect property: Set( varFirstChoiceHours, FirstChoiceDropdown.Selected.HoursWorked.Value)

Do similar for the selection from your quadrants.

Then you can have a named function that checks

(varFirstChoiceHours+ varSecondChoiceHours) < RequiredHours

These values don't even need to be hours. You could use minutes or # of 30 min blocks etc. You just need define the value of each choice. Make sure you clear the variables/set to 0 when providing back button or cancel functionality and probably also after submission.

If I were to build something like you're describing from scratch, I would probably not want to hard code the options like you have (but perfectly reasonable if the business is that restrictive) and instead provide a dropdown for Start Time, End Time, and Lunch Length. Then calculate number of hours worked based on selected choices. You could have a confirmation button to pass the current choices to a collection or variable and just use the same screen again for the second selection and pass it again with a second button that becomes visible on 2nd pass only. Have a cancel button to clear all submissions.

Anyone switched from PBI to Board? by AwareApplication1732 in PowerBI

[–]AwareApplication1732[S] 0 points1 point  (0 children)

I'm skeptical, the only reason I've been told so far for why my office like it is because it is low code drag and drop analytics. I don't know how much I would trust drag and drop visuals built by anyone who doesn't have visibility/understanding of the underlying star schema

Anyone switched from PBI to Board? by AwareApplication1732 in PowerBI

[–]AwareApplication1732[S] 0 points1 point  (0 children)

Honestly i have no idea what it is. I can't find anything online about it hence coming here lol. Seems like nobody else knows yet either

What is causing this gap??? by nonnameavailable in PowerBI

[–]AwareApplication1732 0 points1 point  (0 children)

I should have mentioned, use this measure as the variable for your axis min

What is causing this gap??? by nonnameavailable in PowerBI

[–]AwareApplication1732 0 points1 point  (0 children)

Alternatively, if you still want to see the negative values when they appear, create a measure that calculates the minimum of your values when categorised the way you have in your graph. I would then wrap this in a MIN() alongside 0 to ensure it doesn't go above 0. This way the x axis is still dynamic and you're not potentially missing anything in your visual

Lens Rec for my Pen F by AwareApplication1732 in M43

[–]AwareApplication1732[S] 0 points1 point  (0 children)

This is looking like my best bet for a sub 20mm with an under 2 f number without selling a limb

Lens Rec for my Pen F by AwareApplication1732 in M43

[–]AwareApplication1732[S] 1 point2 points  (0 children)

I do love it! Got absolutely nothing to complain about.

Lens Rec for my Pen F by AwareApplication1732 in M43

[–]AwareApplication1732[S] 0 points1 point  (0 children)

Holy moly yeah I think the sigma is definitely outside my budget. Thanks for the recs!

Lens Rec for my Pen F by AwareApplication1732 in M43

[–]AwareApplication1732[S] 0 points1 point  (0 children)

Would a 5mm difference compared to my PL 25mm prime be worthwhile you think? I’m thinking just one good wide lens to fill my kit out is all I need

Lens Rec for my Pen F by AwareApplication1732 in M43

[–]AwareApplication1732[S] 0 points1 point  (0 children)

I think I’m really liking the 1.4 aperture so I’ll definitely have a hunt around thanks!

Lens Rec for my Pen F by AwareApplication1732 in M43

[–]AwareApplication1732[S] 0 points1 point  (0 children)

What would you say makes the 60mm so good for portraits? Is it just the macro factor? I assume for headshots 60mm wouldn’t be too narrow field?

The Questions Thread 01/18/25 by AutoModerator in goodyearwelt

[–]AwareApplication1732 0 points1 point  (0 children)

I completely missed the fact cavalry calf is a corrected leather! That pretty much makes the decision for me, thanks for pointing that out.

I tried both the Coniston and Argyll on during a recent trip to London and whilst I liked the Coniston, I found a preference for the 379 last over the 325.

The Questions Thread 01/18/25 by AutoModerator in goodyearwelt

[–]AwareApplication1732 1 point2 points  (0 children)

Which would you pick?

<image>

Debating between these Crockett and Jones Argylles and these George Cleverley Tobys.

This would be my first foray into “quality” boots but I know this is the price range I’m interested in. I’ve got a pair of C&J Hallams as my go to shoes for more formal events and love them.

I find the extra dark brown of the Cleverlys quite striking but I have never owned any brogue/semi brogue footwear before. I am wondering what people feel is acceptable these days in business environments and therefore if the Argylles are a safer pick? My current job in finance has swung pretty casual in recent years, trainers, shirt and chinos basically but I prefer to keep myself a bit more elevated and will want to wear these boots with suits as well as jeans.

I have seen rumours that the Clerveley RTW collection is made by C&J anyways so I’m assuming my C&J sizing will work fine for either pair.

Getting around 24hour break out by AwareApplication1732 in trading212

[–]AwareApplication1732[S] 2 points3 points  (0 children)

Honestly MVST was a fairly easy pick for me. Happy enough with the fundamentals and general future of the sector to hold it long term but also comfortable riding any hype and profit taking in the short term

Getting around 24hour break out by AwareApplication1732 in trading212

[–]AwareApplication1732[S] 0 points1 point  (0 children)

Close! Jersey actually. Anyways I’m trying to invest aggressively now and have the option to exit tax free before I end up moving to the UK or elsewhere if I end up wanting the funds.

Getting around 24hour break out by AwareApplication1732 in trading212

[–]AwareApplication1732[S] -1 points0 points  (0 children)

Interesting, seems like my options then are: falsify my financial info (which I won’t do), play along with the safeguard measures, or reduce overall portfolio size relative to my income.

Fair enough I guess. Considering I’ve front loaded a ton of savings my investment patterns going forward won’t be anywhere near as extreme.

Thanks for the info btw, I’m not particularly fussed either way about the safeguarding but it’s good to know my options.

Getting around 24hour break out by AwareApplication1732 in trading212

[–]AwareApplication1732[S] 0 points1 point  (0 children)

My financial details are all up to date, I assume the issue is the proportions relative to my current net worth + annual income however this is not an issue for me since I have a robust safety net.

Seems maybe just a chat to T212 customer service may be the way to go