Last financial year to date

[maurcoll]

Hi 

I am trying to calculate the last financial year to date. I have the following two measures. The current financial year to date is working as it should from 1st April 25 to today (19th May 25). However the last financial year to date is calculating up to the end of the current month 1st April - 31st May 24

I have tried using same period last year and the below measure but get the same result. If i use the date from the calendar table i get a blank result even though the date in the call table is joined onto the calendar table on a one to many single direction and is Active.

FYTD - 

Calculate ([Total Calls],
DatesYTD(Call [Start Dtae], "03/31"))

LFYTD = 

calculate ([FYTD Total Calls],
DatesYTD(dateadd(Call [Start Date], -1, Year), "03/31"))

[GrowthNatives · Accepted solution]

Hi @maurcoll ,
I understand you are facing an issue with calculating last financial year to date. For a more robust approach, I would do it like this :

LFYTD =
CALCULATE (
[Total Calls],
DATESBETWEEN (
    'Date'[Date],
    DATE (YEAR (TODAY ()) - 1, 4, 1),
    DATE (YEAR (TODAY ()) - 1, MONTH (TODAY ()), DAY (TODAY ()))
    )
)

 ⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]

[maurcoll]

That has worked thank you

[bhanu_gautam]

@maurcoll , Try using

LFYTD =
CALCULATE(
[Total Calls],
DATESYTD(
SAMEPERIODLASTYEAR(Call[Start Date]),
"03/31"
)
)

[maurcoll]

Hi

Thank you  but i have already tried that and get the same result