https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Switch-and-Multiply/m-p/3334869#M125054 <P>Hi All!</P><P>&nbsp;</P><P>I'm looking to write a function similar to the image below:<BR /><BR /></P><P><img /></P><P>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!</P> Mon, 17 Jul 2023 16:52:54 GMT am_i_really 2023-07-17T16:52:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Switch-and-Multiply/m-p/3334869#M125054 <P>Hi All!</P><P>&nbsp;</P><P>I'm looking to write a function similar to the image below:<BR /><BR /></P><P><img /></P><P>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!</P> Mon, 17 Jul 2023 16:52:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Switch-and-Multiply/m-p/3334869#M125054 am_i_really 2023-07-17T16:52:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Switch-and-Multiply/m-p/3391817#M127869 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="490352" data-lia-user-login="am_i_really" class="lia-mention lia-mention-user">am_i_really</a>&nbsp;</P><P>&nbsp;</P><P>I would first create a index column as multiplier in Power Query. Pay attention to start with number 1.</P><P><img /></P><P>&nbsp;</P><P>And then, use this measure:</P><LI-CODE lang="markup">Medida 2 = SUMX(MyTable, MyTable[Value]*MyTable[Multiplier])</LI-CODE><P><img /></P><P>&nbsp;</P> Tue, 22 Aug 2023 07:32:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Switch-and-Multiply/m-p/3391817#M127869 mlsx4 2023-08-22T07:32:43Z