Forum Discussion

vladm's avatar
vladm
New Member
8 years ago
Solved

Comulative Values with Categories

Hello,   I am trying to build a custom column with comulative values. So far, I accomplished the folllowing:   DATE / PV (Value) / comPV (Comulative Value)     The DAX expression used he...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi vladm,

     

    Please try this:

    comPV =
CALCULATE (
    SUM ( TABLE_NAME[PV] ),
    FILTER (
        TABLE_NAME,
        TABLE_NAME[CATEGORY] = EARLIER ( TABLE_NAME[CATEGORY] )
            && TABLE_NAME[DATE] <= EARLIER ( TABLE_NAME[DATE] )
    )
)

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi vladm,

 

Please try this:

comPV =
CALCULATE (
    SUM ( TABLE_NAME[PV] ),
    FILTER (
        TABLE_NAME,
        TABLE_NAME[CATEGORY] = EARLIER ( TABLE_NAME[CATEGORY] )
            && TABLE_NAME[DATE] <= EARLIER ( TABLE_NAME[DATE] )
    )
)

Best regards,
Yuliana Gu