Forum Discussion

marsvyl1004's avatar
marsvyl1004
Frequent Visitor
5 years ago

Net Change for Status/Milestone Changes in Report

Hi all. I am trying to show the net change for every day for each milestone (currently using DevOps to retrieve the data).   Below is an image of my overall data and the count of the new IDs added....
General Comment
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi marsvyl1004 ,

 

First create 1 slicer tables,such as below:(It is used to record the values selected at the first time)

slicer table 1 = VALUES('fact table'[ID])

Then create a measure as below:

Measure = CALCULATE(MAX('fact table'[value]),FILTER(ALL('fact table'),'fact table'[ID]=SELECTEDVALUE('slicer table 1'[ID])))-CALCULATE(MAX('fact table'[value]),FILTER(ALL('fact table'),'fact table'[ID]=SELECTEDVALUE('fact table'[ID])))

Put the measure in a card visual,you will see the result as you need.

Here is a sample .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

  • marsvyl1004's avatar
    marsvyl1004
    Frequent Visitor
    5 years ago

    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

    _______________________________

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      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!