Tag: Business Intelligence

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

How To Use The CROSSJOIN Function – Power BI & DAX Tutorial

CROSSJOIN is a really effective function that you can utilize inside of Power BI to essentially bind two tables of data together. It’s not just about selecting any two tables from your data sets. What you can do is actually also manipulate tables inside of the CROSSJOIN function so they can be joined in a

Continue reading

Enterprise DNA Learning Summit – August 2018 [Event Announcement]

The next Enterprise DNA Learning Summit is just around the corner. We’re taking the content up another level for this one. There will be a significant amount of content covered during these advanced Power BI development sessions planned for this event – 6 free live workshops in total. Yes, this is a completely free training

Continue reading