Forum Discussion

USEERTEST51151's avatar
USEERTEST51151
Frequent Visitor
1 year ago
Solved

Cumulative Value Multiplication

Hello everyone, I’m encountering an issue with a cumulative measure I’m working on, and I’d appreciate some guidance. The desired output format looks like this: Year Measure1 Cumulative 2019 1...
Need Help
  • DataNinja777's avatar
    DataNinja777
    1 year ago

    Hi USEERTEST51151 ,

     

    Building on the measure provided by saud968 , I've tweaked it to introduce the base year 2019 to use 1 instead of 1.08 as shown below:

     

    Cumulative Measure = 
VAR CurrentYear = MAX('Table'[Year])
RETURN
    CALCULATE(
        PRODUCTX(
            FILTER(
                ALL('Table'),
                'Table'[Year] <= CurrentYear
            ),
            IF('Table'[Year] = 2019, 1, 'Table'[Measure1])  // Use 1 for 2019, Measure1 for other years
        )
    )

     

    The resulting output is as shown below:

    I've attached an example pbix file for your reference.

     

    Best regards,

anmolmalviya05's avatar
anmolmalviya05
Super User
1 year ago

Hi USEERTEST51151, Please try the below measures.

Cumulative Measure =
VAR CurrentYear = MAX('Table'[Year])
RETURN
IF(
CurrentYear = 2019, -- Base case for 2019
1,
CALCULATE(
PRODUCTX(
FILTER(
'Table',
'Table'[Year] <= CurrentYear -- Include all rows up to the current year
),
'Table'[Measure1]
)
)
)