| Week-Based Time Intelligence in DAX |
| Written by Marco Russo |
| Tuesday, 19 February 2013 20:08 |
|
The DAX language provides several Time Intelligence functions that simplify writing calculations such as year-to-date (YTD), year-over-year (YOY) and so on. However, if you have special calendar structure such as 4-4-5 weeks' calendar, you need to write your custom time intelligence calculation. In this article, you will learn how to write the required DAX formulas. Read more... |
Latest Author Articles
- Grouping Transactions by Age of Customers in DAX
- LASTNONBLANK and FIRSTNONBLANK functions work with any column #dax #powerpivot #ssas #tabular
- SQL Down Under Podcast - Guest: Marco Russo
- Week-Based Time Intelligence in DAX
- The Right Version of Excel 2013 for using PowerPivot #powerpivot #excel
