Forum Discussion

great_AS's avatar
great_AS
Frequent Visitor
3 years ago
Solved

WoW sales variation

Hello,   I can't get the WoW variation, can you please help me out?   I have an excel with: Year: 2019-2022 Week: 1-52 KPIs: sales, profit revenue Countries: yyyyy   First I need to creat...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi great_AS 

     

    You can try measures like below

    LW Sales = CALCULATE(SUM('Table'[Sales]),'Table'[Week]=WEEKNUM(TODAY())-3)
    Sales Variation = DIVIDE([LW Sales],CALCULATE(SUM('Table'[Sales]),'Table'[Week]=WEEKNUM(TODAY())-4))-1

    For other KPIs, you can create similar measures. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi great_AS 

 

You can try measures like below

LW Sales = CALCULATE(SUM('Table'[Sales]),'Table'[Week]=WEEKNUM(TODAY())-3)
Sales Variation = DIVIDE([LW Sales],CALCULATE(SUM('Table'[Sales]),'Table'[Week]=WEEKNUM(TODAY())-4))-1

For other KPIs, you can create similar measures. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!