Switch and Multiply

[am_i_really]

Hi All!

I'm looking to write a function similar to the image below:

For example if column one is 20%, I need the values in that row to be multiplied by 1 and so on. Thanks in advance!

[mlsx4]

Hi @am_i_really 

I would first create a index column as multiplier in Power Query. Pay attention to start with number 1.

And then, use this measure:

Medida 2 = SUMX(MyTable, MyTable[Value]*MyTable[Multiplier])