Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Weekly increase measure

I would like to track the weekly increase/decrease of count of items sold, but I'm not sure how to calculate a Weekly Change measure. Please see data sample and desired visual below. Thank you in adv...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    you can create a column

    Column = 
VAR last=maxx(FILTER('Table','Table'[Category]=EARLIER('Table'[Category])&&'Table'[Date]=EARLIER('Table'[Date])-7),'Table'[Sold])
return if(ISBLANK(last),0,'Table'[Sold]-last)

  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Please check the below picture and the sample pbix file's link down below.

    All measures are in the sample pbix file, and the steps are numbered in front of each measure.

     

     

     

    https://www.dropbox.com/s/1yw1ufdfd7v3daa/nawlins.pbix?dl=0 

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: https://www.linkedin.com/in/jihwankim1975/

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file, and the steps are numbered in front of each measure.

 

 

 

https://www.dropbox.com/s/1yw1ufdfd7v3daa/nawlins.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: https://www.linkedin.com/in/jihwankim1975/