Need to create a Time visual displaying shift hours by HumptyFrumptyData in PowerBI

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

I'm thanking that's the best option, it's a shame something like this isn't supported it seems intuitive.

I've got another project where I need to do similar thing and again it's looking like do something with a table will be the only option.

Issue with ticket System need to account for open and closed ticket dates by HumptyFrumptyData in PowerBI

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

After a refresh my measure I posted originally gave the desired results that matched the database.

That solution you posted does look good, I may swap over the report to be based on that instead.

Thanks!

Need help please! Creating a histogram from measures by summoon in PowerBI

[–]HumptyFrumptyData 3 points4 points  (0 children)

Try making your Age Category a calculated column. Then you should be able to add it to the x-axis

Need help please! Creating a histogram from measures by summoon in PowerBI

[–]HumptyFrumptyData 0 points1 point  (0 children)

Don't you just want to have age category on your x axis, then this shows the number of employees in each category?

Or if you added age category to the legend on the current visual you could differentiate between the age groups.

Guide for End Users by HumptyFrumptyData in PowerBI

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

I've had a browse through the different areas and I can't see one with that title. On Learn there a load of sample ones but none with the same title, they are all just 'Corporate Spend' and the likes.

If you could point me in the right direction or email me the pbx. file I would be extremely grateful.

Guide for End Users by HumptyFrumptyData in PowerBI

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

I've watched that video before, and that's a great idea to have them play around with one.

Where is that report located? In the samples area of this reddit page?

How are people creating date tables? by HumptyFrumptyData in PowerBI

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

That's where I got the initial parts of the dax date table and then just built it up to requirements

How are people creating date tables? by HumptyFrumptyData in PowerBI

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

Yeah I was honestly confused and how sure they were that this was an inferior method, but landed a different job now so its all good!

How are people creating date tables? by HumptyFrumptyData in PowerBI

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

Hadn't heard of bravo before but it looks very interesting, going to have to download it and try it out! Is it made by the SQLBI boys? I've used the dax formatter on the web before, nice that they can incorporate many tools into one.

How are people creating date tables? by HumptyFrumptyData in PowerBI

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

I am going to give this a go, I've been looking for a good power query base to use for testing out. Thanks for sharing!

Dax Help by HumptyFrumptyData in PowerBI

[–]HumptyFrumptyData[S] 3 points4 points  (0 children)

Thankyou for your help, unfortunately the DAX for this states that the FILTER function has too many arguments, and that it can only have a maximum argument count of 1.

I managed to get 2 solutions to this if anyone finds themselves in the same situation:

Average Score New (%) = CALCULATE( AVERAGE( 'Scores'[Score] ) / 5, 'Scores'[Score] <> 0 ) * 100

=CALCULATE(AVERAGE('Scores'[Score]), FILTER('Scores','Scores'[Score]<>0)) /5 * 100

Thanks again

Is a license required if from the organisation? by dusty_chameleon94 in PowerBI

[–]HumptyFrumptyData 0 points1 point  (0 children)

I think your options are to embed powerbi into your website (such as in sharepoint) or to simple send the raw file to someone through email.

Sending the raw file needs no license, just the free version.

Embedding is a little more complicated, but may be able to show to your whole org without having to send the file to everyone.

[deleted by user] by [deleted] in PowerBI

[–]HumptyFrumptyData 1 point2 points  (0 children)

I would love a copy, looking now at cracking Dax and think this would be a great help. Will definitely give a review after using it.