Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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...
@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...
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |