Forum Discussion
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 advance for your assistance.
| Category | Date | Sold | Weekly Change |
| Shirts | 4/19/2021 | 288522 | 0 |
| Pants | 4/19/2021 | 14616 | 0 |
| Shirts | 4/26/2021 | 295452 | 6930 |
| Pants | 4/26/2021 | 15852 | 1236 |
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)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.
2 Replies
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)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.