Forum Discussion
Fiscal Year To date compared to previous
- 2 years ago
NewbieJono So TOTALYTD is one of the very few DAX TI functions that includes an optional 4th parameter that allows you to work with calendars other than standard Gregorian calendars. TOTALYTD function (DAX) - DAX | Microsoft Learn
That said, I highly recommend not going down the DAX TI route. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
NewbieJono So TOTALYTD is one of the very few DAX TI functions that includes an optional 4th parameter that allows you to work with calendars other than standard Gregorian calendars. TOTALYTD function (DAX) - DAX | Microsoft Learn
That said, I highly recommend not going down the DAX TI route. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008