Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
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
YTD =
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 :
measures :
I think my FY Tags are throwing of the YTD measure. Any help and best practice guidance will be super useful!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |