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
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
Getting totals correct inside your Power BI reports can sometimes be the most frustrating thing when utilizing DAX measures. The key to understanding how totals are calculated is to learn in-depth, how context works inside of Power BI. In this tutorial, I’ll go through several different examples of how to fix totals. By doing this,
Recently I had a unique question pop up at the Enterprise DNA Support Forum. In this scenario, we are looking to evaluate YTD sales but we don’t want to evaluate anything past the last sale that may have occurred. We only want to show the cumulative YTD total up to the last sale. This is
In this example, I dive into one of the most advanced DAX functions in Power BI called TREATAS. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards which you might be creating inside of Power BI desktop. TREATAS will helps greatly in the simplification of
