Forum Discussion
Solved
Last Fiscal Year Total by Month - DAX
Hi, I have tried to create one DAX expression to calculate the total amount of one column based on the fiscal year. The report will show the comparison between the current fiscal year and the previo...
It seems that you can use SAMEPERIODLASTYEAR Function directly.
SAMEPERIODLASTYEAR ( DimDate[FullDate] )
v-chuncz-msft
Community Support
Community Support
It seems that you can use SAMEPERIODLASTYEAR Function directly.
SAMEPERIODLASTYEAR ( DimDate[FullDate] )
Exactly! Changing the measure, the first one I've sent on my initial post, to use directly SAMEPERIODLASTYEAR works.
Solution:
CALCULATE (
SUM ( Customer[Income] ),
SAMEPERIODLASTYEAR (DimDate[FullDate]),
ALL ( DimDate )
)
Thank you very much for your help!
Danilo Castro