Here I dive into the AVERAGEX function. By learning and understanding how to use this function, you very quickly open up a range of analysis that can be incredibly insightful and valuable. Maybe you want to work out the average sales you make per day, per month, per customer, per day, and so on. There
Tag: Business Intelligence
The next Enterprise DNA Learning Summit is just around the corner. We’re doing something slightly different this time around and will be reviewing the best and most popular content that has come out of previous learning summits. There will be a significant amount of content covered during these advanced Power BI development sessions planned for
The DATEADD function is by far my go to time intelligence function in DAX at the moment. Mainly because of it’s immense versatility to generate time comparisons over a range of different time frames. This detailed video will go through all the various aspects of how to set up time comparison analysis with this function.
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 tutorial, I will show you how you can create a totally dynamic Power BI report. When I say dynamic, what I mean is that you may want to showcase one particular insight across all of your visualizations in your report page, but then you might want to be able to select a different