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.
Tag: Business Intelligence
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
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
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