RANKX is a very unique DAX function that requires a deeper level of thinking around its logic and also in how it actually works when running a calculation in a particular context (for example a table or chart inside of Power BI). Each different parameter within the RANKX function can change the way in which it
I want to touch on a really important topic within this tutorial. In many of the showcase demos that Enterprise DNA releases across webinars, summits, and to Enterprise DNA members you will see that the use of measure groups is extensive. There is a very good reason why measure groups have been implemented in all
Sometimes you want to filter your data by financial or fiscal years versus filter by calendar years. This particular tutorial is going to cover how you can do just that. What we’re going to do is use a current date table that we may already have inside of our model. If you want to learn
In this example, I’m going to show how you can create Cumulative Totals which are not over dates in Power BI. To create cumulative totals over dates inside of Power BI is not too difficult. There’s a set of formula pattern that you can utilize and reuse for whatever type of cumulative total results you
This week we will have the next scenario-method event from Enterprise DNA. These particular workshop sessions are for enterprise DNA members only. If you are a member and want to find out more about this particular event and register you can at this link below. Expanding On Financial Reporting Templates – September 2018 I’m really
