A naukri.com initiative
Towards Data Science
1M
272
Image Credit: Towards Data Science
Advanced Time Intelligence in DAX with Performance in Mind
- The article discusses advanced Time Intelligence in DAX with a focus on efficiency and performance.
- It covers scenarios not easily handled by standard Time Intelligence functions and uses an extended date table for support.
- Examples include aligning Fiscal Year with the calendar year for calculations like Year-to-Date (YTD).
- The article demonstrates working with the ContosoRetailDW data model and focusing on enhancing DAX performance.
- Utilizing DAX-Studio for performance analysis and emphasizing server timing for efficiency evaluation.
- The article details calculating rolling sums over past periods and addressing challenges like leap years in DAX calculations.
- It showcases methods for handling weekly analysis and building custom weekly measures like Week-to-Date (WTD).
- The article also delves into handling Year-to-Date (YTD) calculations starting from the first day of the first week of the Fiscal year.
- Emphasis is placed on creating an extended date table to simplify DAX calculations and improve performance.
- Various approaches and DAX codes for daily and weekly YTD calculations are provided, highlighting efficiency considerations.
Read Full Article
15 Likes
For uninterrupted reading, download the app