Power BI Accelerator Week #3 is Live!

[Keith]

Hi @BrianJ,
Just to let you know I received mine last night.

thanks
Keith

[BrianJ]

@stevens ,

Thanks – that’s a nice construct. I’ve popped a copy of that into Analyst Hub for future reference/use.

Highlight Highest and Lowest Value in Range - Analyst Hub by Enterprise DNA

– Brian

[Eze]

Hi @BrianJ
Please see below for my submission to the Accelerator Week#3 task.
Here is a screenshot of the data model i used

The report page is below;

Attached is the pbix file, can you please help me publish it.
ClientProfitability.pbix (1.8 MB)

Learning Outcome

1. I was able to learn more about the differences between the ALL and ALLSELECTED functions
2. Had to create a new calculated column (YearQuarterKey) in the Dates table and use that to sort the YearQuarter field (Not sure if this is the best approach though, any ideas are welcome)
3. Struggled with the Above, Below Average and Unprofitable computations. Will appreciate any help on this

Thank you all, feedbacks will be greatly appreciated

[JBocher]

Hi @BrianJ

Here is my submission to the PBI Accelerator Week#3.
Very interesting work on context.
Thank you

Summary

EDNA Power BI Accelerator - Week 3 - JBocher.pbix (9.7 MB)

[BrianJ]

@JBocher ,

Spot on in every respect. Very nice approach on the min/max profitability map visual.

Well done, and thanks for participating!

• Brian

[DavieJoe]

Please see attached

EDNA Power BI Accelerator – Week 3 Problem Final DJ.pbix (9.7 MB)

[BrianJ]

@DavieJoe ,

Nailed all four perfectly. Well done!

Thanks for participating!

• Brian

[BrianJ]

@Eze ,

Excellent effort. Still some learning here to be done, but that’s what this initiative is all about. I think it will make the solution we go over tomorrow much more resonant and meaningful for you given the effort you’ve put in.

Thanks for partipating!

• Brian

[DavieJoe]

I’ll confess, it took a bit of trial & error, my DAX requires a lot of work.

[BrianJ]

@DavieJoe ,

If it worked the first time, it wouldn’t be DAX…

• Brian

[DavieJoe]

Hahahah, good point!

[stevens]

@DavieJoe Thanks for showing how minx and maxx works on the state visual. You made it look easy!

[DavieJoe]

I did have to play around with it a bit, I’d done something similar for the first accelerator entry.

[DavieJoe]

@stevens Think I first picked it up from this video by Curbal[spoiler]

https://youtu.be/uial9zxDmfU

[/spoiler]

[MehdiH]

Hi,
Thanks so much for the week 3 problem.

It took me a while to figure out which metrics are needed to solve the Mockup and what gave me the most trouble is the formatting of the “Shape Map” visual.

This exercise has been very useful and very informative to me and I look forward to the solution that you will present later.

Please find below my proposal for the week 3 problem.

EDNA Power BI Accelerator – Week 3 Problem Final from Week 2- MehdiH.pbix (9.6 MB)

[mhough]

I can give myself 3 out of 4 here, as the shape map didn’t work out and I chose to review a solution from another member here. Thank you for these accelerator exercises. I’m finding that there is so much that I understand when reviewing video, DAX code, etc., but it is another thing to be able to write it creatively and understand proper syntax. The practice is useful.

EDNA Power BI Accelerator – Week 3 Solution MHough.pbix (9.7 MB)

[sam.mckay]

Here’s my submission

Enjoyed going over this during the webinar.

I jazzed up my visuals a little bit to make the insights stand out.

Sam

[The_Bishop]

Can anyone help in linking me to the Accelerator week 3 solution video replay? I watched part of it and wanted to finish it off, but I cannot now find it.

[Keith]

Hi @The_Bishop ,
the replay was sent to me in email message. Check your personal email box also it might have gone to your junk box.

thanks
Keith

[Keith]

HI @BrianJ

when i click on the replay for the Week #3 in the email message. Its not in the Course material

Could you please check it out?
thanks
Keith