YoY calculation based on Year

[POWER_TESTING]

Hi Community,

can you please help me, 

i need to calculate YoY based on Year - don't have proper date.

please find the attachment

[amitchandak]

@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_0uA

[POWER_TESTING]

I 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.....

[v-lionel-msft]

Hi @POWER_TESTING ,

Generally, you need to create a calendar table first.

Custom Year-Over-Year Calculation in DAX - SQLBI

Power BI - Year over Year (YOY) Reports using SAMEPERIODLASTYEAR - Carl de Souza

Solved: How to do YOY and QOQ calculation using DAX - Microsoft Power BI Community

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@POWER_TESTING 

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))