Forum Discussion
Solved
LY calculation wrong total
Hi all, I had the table below intially as my output; And since i only want to show and calculate LY data up to the October (since my CY data is only available untill Oct) i used the fol...
Mous007 , Change the measure like this and try
LY Consumption = sumx(values('Dates table'[Period]),IF(ISBLANK( [CY Consumption]) , BLANK(),
Calculate([CY Consumption],DATEADD('Dates table'[Date] , -1 , YEAR))))
Perfect thank you.
& happy new year in advance 🙂