Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |