YoY Growth

[Anonymous]

Hi, 

why my yoy growth is not working here?

Hope you could have a look at it and please help me to fix it!!

Thanks 

Revenue = CALCULATE(sum(Orders[Sales]))

Revenue Same Period Last Year = 
CALCULATE(
    [Revenue];
    DATEADD(Orders[Order Date];-1;YEAR)
)

YoY Growth Revenue = IF([Revenue Same Period Last Year]=0;0;[Revenue]/[Revenue Same Period Last Year]-1)

My data is:    sample_superstore

The power bi file: https://we.tl/t-vJEvq5TKAQ 

[v-xicai · Accepted solution]

Hi @Anonymous ,

The DATEADD() function require contiguous date selection.

You can create calendar table first of all, create relationship between the Orders table and calendar table on date field, then change the [Revenue] and [Revenue Same Period Last Year] like DAX below

DateDim= CALENDARAUTO()
 
Revenue= TOTALYTD(SUM(Orders[Sales]),'DateDim'[Date])
 
Revenue Same Period Last Year = CALCULATE(SUM(Orders[Sales]),SAMEPERIODLASTYEAR('DateDim'[Date]))

Best Regards,

Amy

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

[Anonymous]

Thanks for spending time to help me!!

It works well