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.
You can download the Power BI (pbix) file below and follow along throughout the video. Just let us know where to send the file.
In the video I go through what you can do with the DATEADD function, and also how you can quickly compare multiples of different time periods really extremely fast.
I think you’ll be amazed at how easy it is to actually do this type of analysis using DAX in Power BI.
Watch the video from the Enterprise DNA TV channel on YouTube
I’m hoping that from grabbing the download and watching through the video you’ve now got a much better understanding of how great the DATEADD function is.
There’s so much you can do with it right?
Thanks for checking it out.
Catch you next time