March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
4 | |
4 | |
4 | |
3 | |
3 |