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? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #TimeIntelligence
- The DATEADD Function - The Best and Most Versatile Time Intelligence Function In DAX [2022 Update] ( Download)
- The DATEADD Function - The Best and Most Versatile Time Intelligence Function in DAX ( Download)
- DATEADD() Function: Unlocking Advanced Time Intelligence in Power BI ( Download)
- Power BI DAX Tutorial (9/50) - What is DateAdd Function ( Download)
- Understanding the versatile DATEADD Function in DAX ( Download)
- Using The DATEADD Function For Effective Time Related Insights - Power BI ( Download)
- Power BI - DAX function - DATEADD ( Download)
- SAMEPERIODLASTYEAR vs PARALLELPERIOD vs DATEADD // DAX Basics // Beginners Guide to Power BI in 2022 ( Download)
- DATEADD, SAMEPERIODLASTYEAR - DAX Guide ( Download)
- Time Intelligence Functions in DAX | DATEADD, DATESMTD, DATESINPERIOD ( Download)
- My number 1 trick for TIME INTELLIGENCE | Power BI DAX ( Download)
- Power BI Interview Questions- Minus 1-year using DATEADD, what date is expected for the first date ( Download)
- Power BI Series - DATEDIFF & DATEADD ( Download)
- How to use DATEADD function in power bi | DAX | part 14 ( Download)
- DATE, TIME - DAX Guide ( Download)
