Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
Can you please help me with DAX to create a measure that, which can add the total of the budgeted YTD sales for current fiscal year and a seperate mesure for sales of last year. Since I will be uploading the data for the future year in the file in future thus I would like to know if there is a way I can setup a DAX, which calculates the number of sales based on the fiscal year correctly as compare to I having to go and change the measure every time. Please advise how can I do that. This is the result I'm looking for.
Last Fiscal Year | Proposed Budget | |
Net Sales | 3000 (Net Sales) (2022-2023) | 5500 (Net Sales YTD Budget) (2023-2024) |
Currently I have setup a measure:
My Data:
Hi @Kifl2023 ,
It is not clear how to draw the fiscal year. I suggest you can use TODAY() to return today's date, calculate which fiscal year this date is in, and then replace it with '2023-2024' as a variable. This way, as today's date changes, this variable will also change.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum