Forum Discussion
All and YoY Question
I am 2 issues want to clarify but my ultimate is to calculate the YoY using sameperiodlastyear function. 1. I have display 4 matrix table with different DAX, no ALL, 1 ALL (year), 1 ALL (country...
alvin199 , Create a separate year table
example
This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Year'),'Year'[Year]=max('Year'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Year'),'Year'[Year]=max('Year'[Year])-1))
diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
amitchandak thanks for the guide.
Why I cannot use sameperiodlast year function and which the ALL will influence it?
