Forum Discussion

Miguelcrz's avatar
Miguelcrz
Helper I
6 years ago

WEEK VARIATION

Hello,   I need to have the variation % of my sales comparing it vs the last week like this:       My power BI currently looks like this:   And my table of time looks like this (S...
Need Help
Miguelcrz's avatar
Miguelcrz
Helper I
6 years ago

Hi @Anand24 @amitchandak @v-shex-msft @FrankAT ! is not working. I only have the column week and the column sales. I have to calculate or do a new column to calculate the sales from last week but i dont know how. Then i need to calculate the variation between the sales of this week vs last week.

Thanks!

FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi Miguelcrz 

here is another solution to your question. Use the three measures below.

 

 

Regards FrankAT

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Miguelcrz,

      You told us these codes not works without any detailed information, they not help to resolve your scenario and hard to clarify/troubleshoot the issues.
      Can you please provide a pbix file with dummy data and formulas to test? I think it should help for testing the coding formula on your sample data. (remove sensitive data before share)

      How to Get Your Question Answered Quickly 

      Regards,

      Xiaoxin Sheng