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,

saud968's avatar
saud968
Memorable Member
1 year ago

Try this measure 

Cumulative Measure =
VAR CurrentYear = MAX('Table'[Year])
RETURN
CALCULATE(
PRODUCTX(
FILTER(
ALL('Table'),
'Table'[Year] <= CurrentYear
),
'Table'[Measure1]
)
)

If this does not work share some more details. 

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!


saud968's avatar
saud968
Memorable Member
1 year ago

USEERTEST51151 was the above helpful

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!