This is probably very rudimentary, but I am trying to calculate YTD total revenue, based on my fiscal year, (May-April)
I have created the following measure to calculate
Thank for you the help!
@safifaruqi , what is wrong with last table is not very clear, Just make sure you have all there required dates in
Dimension Period table and it is marked as date table
YTD = TOTALYTD([Total_Revenue],'Dimension Period'[Date]) , "4/30")
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thanks for your reply amit, I used your blog to create a FISCAL YEAR Calendar WEEK SORT,
The objective is to simply calculate YTD and YTD LY on a fiscal year basis, for comparison purposes.
When yousing the Fiscal Year Tags (FY Column highlighted in yellow in screen grab above) I get blanks for YTD measure I created against the current FY 2021-2022, but not for rest.
Sample output based on Fiscal year tags :
Sample output based on calendar year and months, which is correct and as expected :
I think my FY Tags are throwing of the YTD measure. Any help and best practice guidance will be super useful!
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!