This tutorial will go through an advanced example on the DAX function RANKX in Power BI. This is a breakout session from the Learning Summit Workshop in Enterprise DNA Online. The RANKX function gives you valuable insights when you use it for a range of different contexts in your report page. However, it can also
I’m going to go through an interesting scenario that you’ll probably land on when you’re trying to run a Cumulative Total inside of Power BI. A member from the Enterprise DNA support forum posted this query. The member wanted to calculate a running balance like a Cumulative Total. The problem was every time a selection
The ALLSELECTED DAX function inside Power BI is one of the more advanced functions that you can utilize within your reports and dashboards. ALLSELECTED DAX function is a derivative of the ALL functions. So there’s ALL, ALLSELECTED and ALLEXCEPT. They all do something similar, which is remove the context or filters. Here, we’ll focus on
I’m going to go over something specific in product budgeting. It’s quite advanced but if you can understand the concepts and the techniques that I go through here, you’ll also have a good understanding of what Power BI can do, how DAX works, and how you can combine a lot of different functions to get
