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,
We are going to get advanced with this tutorial. I will cover how you can create Custom Dynamic Groups inside visualizations with Power BI. What do I mean by Dynamic Groups? Think about a scenario where you have a range of different customers and you want to group them into who you judge are good, average,
In this unique example, I will show you how you can compare a sale, on any particular day to the very last sale that was made. This will be relevant if you don’t actually sell something every single day or if you are looking at a particular customer or a product and you want to
When utilizing SWITCH/True Logic inside of Power BI you really do open up this huge expanse of analytical opportunities. In this tutorial, I will run through in detail how you need to set up your formulas when using the SWITCH function. This will enable you to find, discover, and visualize many different and interesting insights
In this advanced video tutorial which is a breakout of a budgeting workshop that was part of the Enterprise DNA webinar series, I am going to run through how you can utilize some advanced functions inside of Power BI like CALCULATE, ALLSELECTED and SUMMARIZE. By using all the functions in combination we are able to
