The DATEADD Function - The Best and Most Versatile Time Intelligence Function In DAX [2022 Update]

In this tutorial, Sam demonstrates how you can use the DATEADD function — likely the most versatile time intelligence function in DAX. See how you can apply this to complete a huge range of time related calculations in your analysis.

***** Video Details *****
00:00 Introduction
00:54 Creating A Table With Total Sales Measure
01:36 Comparing Current Sales With Sales Last Year Using DATEADD Function
03:21 Other Time Periods That Can Be Used For Comparison
04:15 Calculating The Difference In Sales
05:24 Other Calculations To Branch Into Using DATEADD Function

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #TimeIntelligence

[Bizza]

great video. i was looking to do qoq and yoy growth rates for what feels like hundreds of open source datasets and i have been doing calcs in each query (very slow...) rather than using time intelligence in measures. ty m8