Forum Discussion
YoY Growth
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
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.
2 Replies
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.