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
Anand24's avatar
Anand24
Super User
6 years ago

Hi Miguelcrz ,

 

Can you create a new column with below DAX:

Last Calendar Week Sales = CALCULATE( [Total Sales], 'Calendar'[Week Number] = WEEKNUM(TODAY(),1) -1 )

 

Use this to create another calculated column for % variation with below DAX:

Percent_Variation = (([Total Sales]-[Last Calendar Week Sales])/[Last Calendar Week Sales])*100

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

  • Miguelcrz's avatar
    Miguelcrz
    Helper I
    6 years ago

    Hi! 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 another solution to your question. Use the three measures below.

      15-08-_2020_01-53-27.png

      Regards FrankAT

  • 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