Forum Discussion

kbarber's avatar
kbarber
Frequent Visitor
6 years ago
Solved

Running Total?

Hello, I think I need help with calculating a running total, though I'm not sure.  Apologies if this has been answered elsewhere. I took some time to create an example file.   In the example file...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi kbarber ,

    I create a measure using SUMX function. You could reference it to have a try.

    Measure =
SUMX (
    FILTER (
        FTE,
        FTE[Pos Start] <= MAX ( 'Calendar'[Date] )
            && (
                FTE[Pos End] >= MAX ( 'Calendar'[Date] )
                    || ISBLANK ( FTE[Pos End] )
            )
    ),
    FTE[FTE]
)

     

    Best Regards,

    Xue Ding

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

kbarber's avatar
kbarber
Frequent Visitor
6 years ago

hello Anonymous  - since your use case is different, i'd recommend posting as a new question.  Also, i find if i create a dummy file and link to the post it's more likely to get a response...

- Kurt

Anonymous's avatar
Anonymous
Not applicable
6 years ago
kbarber thanks for you reply ,i need solution for this one ,I have tried may ways but multiplication is not happening during running total values.please let me know if you get any solution for that.