Welcome to the Power BI Community Blog!

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.

Walk Through Of Many Ranking Techniques using DAX in Power BI

by EnterpriseDNA Regular Visitor on ‎10-09-2017 01:49 PM - last edited on ‎10-09-2017 01:50 PM by Power BI Admin mbenjamin

There's so many applications and situations where utilising ranking techniques really add a lot of value in your analysis.
 
I've created many videos over at Enterprise DNA TV which showcase these techniques, so I thought I might review some of these here so you can learn about them more.
 
I'm going to review these techniques but don't forget you could apply these a number of different ways and in lots of situations.
 
1. Find Your Top Customers Through Time Using RANKX in Power BI w/DAX
2. Discover Top Salespeople Contribution To All Sales in Power BI w/DAX
3. Discover The Best Selling Day For Your Products w/DAX in Power BI

 

Enterprise DNA TV logo2.png

Read more...

Using DAX to compare data or metrics over time is incredibly efficient. Using a range of techniques in this post I'll show you how to analysis performance of these metrics over multi-year time periods.

 

Multi Year Performance Analysis.JPG

Read more...

It is amazing how much more efficient it is to complete reasonably technical analysis with Power BI. One business scenario where this will bring huge value to an organisation is when looking to understand your customers better.

Read more...

One type of analysis I like to use quite often is comparing this year totals to last year totals. I want to also always make it as dynamic as possible. All I should have to do is change the context of my calculation (ie. bring in a new dimension like regions/products etc) and everything should automatically re-calculate.

Read more...

Attachment