Multiply rows

[Anonymous]

Hi everybody!

I'm in the process of calculating a YTD Inflation. For this, I have a table of Inflation with Country, Month, GrowthPercentage. The calculation for this is:

For the months of the selected period sum 1 to each growth, multiply all of them, and subtract 1 to the result.

Example: 0.03 >> 1.03

1.03*1.12*1.18*1.01 = 1.37

1.37 >> 0.37 >> 37%

How can I perform this? Because there is SUM and SUMX function, but here what I need is a MULT funcion or something to multiply. Any ideas?

Thanks in advance.

[Phil_Seamark · Accepted solution]

Hi @Anonymous

If I understand you correctly I think the PRODUCT fucntion may probably work.  If you are happy with the essence of the function, it can be extended to work with your data.

Result = 
VAR IndexColumn = Table3[Index]
RETURN CALCULATE(
        PRODUCT(
            'Table3'[Rate]
            ),
            FILTER(
                'Table3',
                'Table3'[Index]<=IndexColumn )
               )

[Anonymous]

So many thanks @Phil_Seamark!

That was exactly what I been looking for. I perfectly performed what I needed.

Have a great day!