Forum Discussion
Net Change for Status/Milestone Changes in Report
v-kelly-msft Thank you for the response! I looked through the solution and understand what is happening, but its not what I'm looking for exactly.
Hopefully this is a better explanation of my issue: Let's say today, my chart data has the following information:
___9/28/2020___ | _________
Build Refinement | 136
Core Build | 487
_______________________________
In the backend, I complete a count for each milestone. Hypothetically speaking, tomorrow, 09/29/2020, my data shows that 7 Core Build was changed to Build Refinement. My graph will show the correct numbers since it is a count (below), however, I want a measure in the tooltip to show -7 for Core Build and 7 for Build Refinement.
___9/29/2020___ | _________
Build Refinement | 143
Core Build | 480
_______________________________
Hi marsvyl1004 ,
Yes,I understand your point,my suggestion is a workaround for you,as in desktop,the previous values cant be stored (It will be overwritten)and then used for calculation,my suggestion is to use a slicer to select the previous values then use the values to calculate out the result you need.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!