Forum Discussion
YoY calculation based on Year
Hi Community,
can you please help me,
i need to calculate YoY based on Year - don't have proper date.
please find the attachment
4 Replies
POWER_TESTING , Attachment is missing. You can do it based on year table(prefer separate table, say date )
This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[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_0uAI don't have Date table, how would I use dates ??
This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))below are my DAX exressions:
MAX_Year_1 = CALCULATE(SUM(Sheet1[Freight]),FILTER(Sheet1, Sheet1[Year]=MAX(Sheet1[Year]) ))Previous_Year_1 = CALCULATE(SUM(Sheet1[Freight]),FILTER(Sheet1, Sheet1[Year]=MAX(Sheet1[Year])-1))but these are working for by defauly, if i select year not working.....is the previous year value not correct?
maybe you can try this
MAX_Year_1 = CALCULATE(SUM(Sheet1[Freight]),FILTER(Sheet1, Sheet1[Year]=MAX(Sheet1[Year]) ))
Previous_Year_1 = CALCULATE(SUM(Sheet1[Freight]),FILTER(ALL(Sheet1), Sheet1[Year]=MAX(Sheet1[Year])-1))
