cancel
Showing results for
Did you mean:
Helper I

## YoY calculation based on Year

Hi Community,

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

4 REPLIES 4
Super User IV

@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

Proud to be a Super User!

Helper I

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.....
Community Support

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.

Super User II

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

Proud to be a Super User!

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.