Tag: Business Intelligence

How to Measure Averages per Day in Power BI with DAX

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

Continue reading

Enterprise DNA Learning Summit – February 2019 [Event Announcement]

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

Continue reading

The DATEADD Function. The Best And Most Versatile Time Intelligence Function in Power BI

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.

Continue reading

SWITCH True Logic Explained For Power BI

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

Continue reading

Dynamic Report Technique For Power BI

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

Continue reading