Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Multiply rows

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 s...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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 )
               )

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

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's avatar
Anonymous
Not applicable
9 years ago

So many thanks Phil_Seamark!

 

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

 

Have a great day!