Forum Discussion

Amedved's avatar
Amedved
Frequent Visitor
2 years ago
Solved

Creating a Rolling, Cumulative Metric in a Matrix Visual

Hi! I am trying to create a measure to add to my matrix visual that is a rolling total. This "Backlog" measure should subtract the current day's "Output" from the prior day's backlog plus the current...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Amedved ,

    I updated your sample pbix file, please find the details in the attachment.  You can create a new calculation to get it:

    Calculation = PREVIOUS([Backlog])+[RemainingQtyTotal]-[Output]

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Amedved ,

I updated your sample pbix file, please find the details in the attachment.  You can create a new calculation to get it:

Calculation = PREVIOUS([Backlog])+[RemainingQtyTotal]-[Output]

Best Regards

Amedved's avatar
Amedved
Frequent Visitor
2 years ago

Thanks very much Anonymous . I was not familiar with visual calculations. I took your suggested approach and got to the desired outcome after I adjusted the formula a bit to meet some requirements. Thanks again for the assist.