Forum Discussion
Post PartisanFiscal Year To date compared to previous
Hello, how would I compare volumes for the fiscal year to day, e.g. April 1st to today? but compare it to the past few fiscal years, e.g
01/01/2024-Today
01/01/2023 - 18/04/2023
01/01/2022 - 18/03/2022
i would need this to by dynamic, e.g this would show 19th tomorrow and so on.
I have a calendar table with fiscal year starting in April.
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
1 Reply
- Greg_Deckler
Community Champion
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