Forum Discussion

erg2494's avatar
erg2494
Frequent Visitor
4 years ago
Solved

How to get running total using a Dynamic Measure

Hello,   I would like to create a running total but use a measure as a starting point. This measure is updated every day. PLease see example below. Is this possible?    For example:   starting_...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi erg2494 , 

    Please refer to my pbix file to see if it helps you.

    Create a measure.

     

    Measure = CALCULATE([starting_measure]+SUM('Table'[Total Daily Movement]),FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])))

     

    If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi erg2494 , 

Please refer to my pbix file to see if it helps you.

Create a measure.

 

Measure = CALCULATE([starting_measure]+SUM('Table'[Total Daily Movement]),FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])))

 

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

erg2494's avatar
erg2494
Frequent Visitor
4 years ago

thank you so much. this worked for me.