This is another video in the Time Intelligence series. From this video, you will learn powerful ways to use the ISAFTERTODAY functionality within the Extended Date Table to dramatically simplify common analytical scenarios.
***** Video Details *****
2:18 data view
4:59 DAX approach
5:13 ALT cumulative sales
6:04 ALT2 cumulative sales
6:22 DAXFilter function
6:27 ISINSCOPE function
6:50 IsAfterToday function
8:17 second case data
9:18 cumulative actual sales
9:54 cumulative forecast sales
*****For more Time Intelligence series, click the links below*****
Create A Holiday Table In Power BI: youtu.be/v9s0PPLU0n8
M Function In Creating Extended Date Table: youtu.be/I2lmtUC3nH8
Date Harvest Deep Dive - Power BI Time Intelligence: youtu.be/mm-Lv6lv4a4
Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables: youtu.be/iveCss_hzDo
Using The Extended Date Table - OFFSETS: youtu.be/Ieh0EhJzJgo
Calculate Workdays Between Two Dates: youtu.be/kRACuS4eKWA
***** 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/
Learn more about Enterprise DNA - enterprisedna.co/
Enterprise DNA Membership - enterprisedna.co/membership
***** Related Links *****
Build A Comprehensive Date Table In Power BI Really Fast - blog.enterprisedna.co/how-to-create-a-detailed-date-table-in-power-bi-fast/
Forecasting in Power BI: Compare Performance vs Forecasts Cumulatively w/DAX - blog.enterprisedna.co/compare-performance-vs-forecasts-cumulatively-wdax/
Data Normalization in Power BI for Different Days Results - blog.enterprisedna.co/normalizing-results-on-different-days-in-power-bi-using-dax/
***** Related Course Modules *****
Time Intelligence Calculations - portal.enterprisedna.co/p/time-intelligence-calculations
Best Practices & Feature Reviews - portal.enterprisedna.co/p/best-practices-feature-reviews
Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
***** Related Support Forum Posts *****
Date Table - How Do I Change It To Get Today’s Date And Avoid Manual Updates - forum.enterprisedna.co/t/date-table-how-do-i-change-it-to-get-todays-date-and-avoid-manual-updates/8019
New Cheat Sheet for Extended Date Table - forum.enterprisedna.co/t/new-cheat-sheet-for-extended-date-table/7283
Extended Date Table (Power Query M function) - forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390
For more extended date table support queries to review see here - forum.enterprisedna.co/search?q=extended%20date%20table
- Using The Extended Date Table - ISAFTERTODAY ( Download)
- Using The Extended Date Table - OFFSETS In Power BI ( Download)
- Introducing The Extended Date Table 2.0 - Power Query M Function ( Download)
- How To Use M Function In Creating Extended Date Table In Power BI - Query Editor Tutorial ( Download)
- Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables - Query Editor Tutorial ( Download)
- Date Harvest Deep Dive - Power BI Time Intelligence ( Download)
- Calculating Workdays Between Two Dates In Power BI ( Download)
- How To Create A Holiday Table In Power BI - Time Intelligence in Power BI ( Download)
- Data Loading And Transformation - Power BI Best Practices Vol. 1 ( Download)
- How To Mask Sensitive Data In Power BI ( Download)
- Excel - IF Date is Before or After Another Date | IF Date is Before or After Today ( Download)
- Offset Magic: Make DAX Time Intelligence Disappear ( Download)
- Offset Magic: Make DAX Time Intelligence Disappear | Business Intelligence Summit Session 15 ( Download)
- An eDNA Tools Lifecycle Approach To DAX Coding | Innovation Labs #2 Session 8 ( Download)
- New and Improved reporting in Pavillio! ( Download)
