cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
POWER_TESTING
Helper I
Helper I

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 4
amitchandak
Super User IV
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
https://www.youtube.com/watch?v=km41KfM_0uA



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

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.

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

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

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors