Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
9 | |
5 | |
3 | |
3 |