Fiscal Year To date compared to previous

[NewbieJono]

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.  

[Greg_Deckler · Accepted solution]

@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-TIT...