Forum Discussion

LD's avatar
LD
Frequent Visitor
4 years ago
Solved

Issue on Cumulative Sum

Dear All, please, I have the following Dataset and I would like to measure the cumulative sum by month of [YTD_in/out]_     I try the following structure: Var LastM = SELECTEDVALUE('Y Proj...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    LD 

    Please use

    =
VAR LastM = 'Y Projection'[Month]
VAR CurrentDepTable =
    CALCULATETABLE (
        'Y Projection',
        ALLEXCEPT ( 'Y Projection', 'Y Projection'[Department] )
    )
RETURN
    SUMX (
        FILTER ( CurrentDepTable, 'Y Projection'[Month] <= LastM ),
        'Y Projection'[YTD_IN/OUT]
    )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

LD 

Please use

=
VAR LastM = 'Y Projection'[Month]
VAR CurrentDepTable =
    CALCULATETABLE (
        'Y Projection',
        ALLEXCEPT ( 'Y Projection', 'Y Projection'[Department] )
    )
RETURN
    SUMX (
        FILTER ( CurrentDepTable, 'Y Projection'[Month] <= LastM ),
        'Y Projection'[YTD_IN/OUT]
    )
LD's avatar
LD
Frequent Visitor
4 years ago

Thank You Tamerj1,

It's fine and the value are exact!!!!