cancel
Showing results for
Did you mean:
Frequent Visitor

## Fiscal Year YTD Calculations

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

YTDLY_Revenue = CALCULATE([YTD_Revenue],SAMEPERIODLASTYEAR('Dimension Period'[Date]))

What I do not get is the output I am getting: The output is working as expected, except I am not getting any YTD value for the FY 2021-2022, where as the prior years are being populated correctly.

Lastly, looking at the YTDLY_Revenue measure output, I am getting the output against all years.

I cant seem to figure out the issue.

when I change the measure to include an end of the year date

YTD =

TOTALYTD([Total_Revenue],'Dimension Period'[Date]) , "4/30")

Then I get the following output

Thank for you the help!

2 REPLIES 2
Super User

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

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
Frequent Visitor

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 :

YTD_Revenue = CALCULATE(TOTALYTD([Total_Revenue],'Dimension Period'[Date]))
Total_Revenue = [Total_CreditNote]+[Total_Invoice]

I think my FY Tags are throwing of the YTD measure. Any help and best practice guidance will be super useful!

Announcements