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.

v-xuding-msft's avatar
v-xuding-msft
Community Support
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

v-xuding-msft  - that worked!!!

thank you so much for taking the time to respond; made my day!

 

In my limited understanding of DAX/Modeling, I thought I'd first have to create table relationships between the tables.  I'm a bit surprised that no relationships are necessary...

 

thanks again,

- Kurt