Check out the 2022 update of this video here: youtu.be/N-77CnEWe0I
Learn how to 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 *****
0:54 Creating A Table With Total Sales Measure
1:36 Comparing Current Sales With Sales Last Year Using DATEADD Function
3:21 Other Time Periods That Can Be Used For Comparison
4:15 Calculating The Difference In Sales
5:24 Other Calculations To Branch Into Using DATEADD Function
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
Learn more about Enterprise DNA - enterprisedna.co/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links*****
Time Intelligence For Non Standard Date Tables In Power BI - wordpress.com/post/blog.enterprisedna.co/81724
Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX - wordpress.com/post/blog.enterprisedna.co/80329
Discover How To Repeatedly Project A Current Trend Forward In Power BI - wordpress.com/post/blog.enterprisedna.co/82598
***** Related Course Modules*****
Time Intelligence Calculations - portal.enterprisedna.co/p/time-intelligence-calculations
Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
Solving Analytical Scenarios w/Power & DAX - portal.enterprisedna.co/p/solving-business-scenarios-with-power-bi-and-dax
***** Related Support Forum Posts*****
Data Modelling base on Custom Time Intelligence Format - forum.enterprisedna.co/t/data-modelling-base-on-custom-time-intelligence-format/1001
Time intelligence Help (Previous Month Calculation) - forum.enterprisedna.co/t/time-intelligence-help-previous-month-calculation/3480
Project Numbers Forward With Time Intelligence Dax Techniques - forum.enterprisedna.co/t/project-numbers-forward-with-time-intelligence-dax-techniques/3399
For more time intelligence support queries to review see here - forum.enterprisedna.co/search?q=time%20intelligence
- The DATEADD Function - The Best and Most Versatile Time Intelligence Function in DAX ( Download)
- The DATEADD Function - The Best and Most Versatile Time Intelligence Function In DAX [2022 Update] ( Download)
- Power BI DAX Tutorial (9/50) - What is DateAdd Function ( Download)
- DATEADD, SAMEPERIODLASTYEAR - DAX Guide ( Download)
- Understanding the versatile DATEADD Function in DAX ( Download)
- Use of DATEADD function to generate time comparisons in P&L. ( Download)
- Using The DATEADD Function For Effective Time Related Insights - Power BI ( Download)
- DATEADD() Function: Unlocking Advanced Time Intelligence in Power BI ( Download)
- SAMEPERIODLASTYEAR vs PARALLELPERIOD vs DATEADD // DAX Basics // Beginners Guide to Power BI in 2022 ( Download)
- My number 1 trick for TIME INTELLIGENCE | Power BI DAX ( Download)
- DAX(DATEADD, DATESINPERIOD, DATESINBETWEEN) ( Download)
- Time Intelligence Functions in DAX | DATEADD, DATESMTD, DATESINPERIOD ( Download)
- Types Of Time Intelligence Functions - (1.17) Ultimate Beginners Guide to DAX 2020 ( Download)
- A Review Of Common Time Patterns To Use In Power BI - DAX Formula Review ( Download)
- Offset Results with DATEADD Function - DAX Let's Play #002 with Wolfman Analytics ( Download)
