Forum Discussion
Anonymous
7 years agoNot applicable
Current year vs Previous year line chart failure
Hello,
When I try to make a line chart of the previous and current year using the meassure
Previous year Amount = CALCULATE([Amount], DATEADD('CalendarDay'[Date],-12,MONTH))
(Current year) Amount - (SUM('Table'[Price]))
I get ithe same data as for the current year, if I apply the measure
Previous year Amount =CALCULATE([Amount],ALL('Table1'[Year]), DATEADD('CalendarDay'[Date],-12,MONTH))
it shows me the sum of all the previous years.
Any idea why? PS. im using Directquery mode
No Replies