Forum Discussion

Zoltan10's avatar
Zoltan10
New Member
4 years ago

Filter for cumulative total

Hi All,   I would like to conditionally summarize categories where we had data until now in the year.   For example:             1th month we had value1 only for cat2, so the result ...
Need Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Zoltan10 
Not sure if I fully understand but you may try following two options (calculated column and measure)

https://we.tl/t-vdDp440B6C

Total Value = 
VAR CurrentMonth = Sheet1[Month]
RETURN
    CALCULATE ( 
        SUMX ( 
            Sheet1,
            Sheet1[Value1] * Sheet1[Value2]
        ),
        Sheet1[Month] <= CurrentMonth,
        REMOVEFILTERS ()
    )

Total Value Measure = 
VAR CurrentMonth = MAX ( Sheet1[Month] )
RETURN
    CALCULATE ( 
        SUMX ( 
            Sheet1,
            Sheet1[Value1] * Sheet1[Value2]
        ),
        Sheet1[Month] <= CurrentMonth,
        REMOVEFILTERS ()
    )