Forum Discussion
Solved
Current FY vs Previous FY
Hi, I'm struggling with a measure that I need to create. Our financial period runs from 01/09 to 31/08 I need to report the Current FY. For that, I'm using a Fiscal CurrYearOffset Date t...
Hi grega - can you try the below measure as per FYCY
Current FYTD Sales =
CALCULATE(
[Total Sales],
DATESYTD(
'Date'[Date],
"08/31"
)
)Create another measure for FYPY
Previous FYTD Sales =
CALCULATE(
[Total Sales],
DATESYTD(
SAMEPERIODLASTYEAR('Date'[Date]),
"08/31"
)
)Try the above logic , let know
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
