Forum Discussion

AlexandraStk's avatar
AlexandraStk
New Member
3 years ago

WoW % Growth Rate

Hello everyone,   I am trying to calculate the week on week growth rate for a sales report (revenue) and can't seem to find a formula that works. I am looking to compare same periods, so for exampl...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi AlexandraStk ,

 

Based on your dataset, you could create a measure to return WoW% Grouth Rate:

 

WoW % Growth Rate = var _pre=CALCULATE(SUM('Table'[Revenue]),FILTER(ALL('Table'),[Year]=MAX('Table'[Year])&&[Weeknum]=MAX('Table'[Weeknum])-1&&[Weekday]<=MAX('Table'[Weekday])))
var _cur=CALCULATE(SUM('Table'[Revenue]),FILTER(ALL('Table'),[Year]=MAX('Table'[Year])&&[Weeknum]=MAX('Table'[Weeknum])&&[Weekday]<=MAX('Table'[Weekday])))
return DIVIDE(_cur-_pre,_pre)

 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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

Mrxiang's avatar
Mrxiang
Icon for Helper II rankHelper II
3 years ago

For the week on week growth rate, you can use the DAX formula SUMX3(FILTER(table, WEEKDAY(date) = WEEKDAY(GETDATE())), revenue, 1). Replace table with your table name and GETDATE() with a cell reference containing the current date. The SUMX3 function calculates the sum of the products of the three arguments. The first argument is the filtered table, the second argument is revenue, and the third argument is 1 (the row number). This formula will give you the growth rate for each day of the week compared to the same day of the previous week.