Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
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)
Proud to be a Super User!
Hi, @nawlins1976
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/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @nawlins1976
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/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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)
Proud to be a Super User!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |