Forum Discussion
Switch and Multiply
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!
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])