https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-between-rows-with-same-ID/m-p/2193293#M51316 <P>Thank you&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="39298" data-lia-user-login="AlexisOlson" class="lia-mention lia-mention-user">AlexisOlson</a>&nbsp;. The solution works magic</P> Tue, 16 Nov 2021 21:56:28 GMT BInovice 2021-11-16T21:56:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-between-rows-with-same-ID/m-p/2193223#M51307 <P>All, my data are structured as below and I need to run the calculated values in the last column. Each ID contains exact same 4 attributes.&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>Attribute</TD><TD>Value</TD><TD>Cal=(A+C+D)/B</TD></TR><TR><TD>ID1</TD><TD>A</TD><TD>6</TD><TD>&nbsp;</TD></TR><TR><TD>ID1</TD><TD>B</TD><TD>2</TD><TD>&nbsp;</TD></TR><TR><TD>ID1</TD><TD>C</TD><TD>3</TD><TD>&nbsp;</TD></TR><TR><TD>ID1</TD><TD>D</TD><TD>1</TD><TD>5</TD></TR><TR><TD>ID2</TD><TD>A</TD><TD>100</TD><TD>&nbsp;</TD></TR><TR><TD>ID2</TD><TD>B</TD><TD>40</TD><TD>&nbsp;</TD></TR><TR><TD>ID2</TD><TD>C</TD><TD>56</TD><TD>&nbsp;</TD></TR><TR><TD>ID2</TD><TD>D</TD><TD>89</TD><TD>6.125</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Alternatively a way to unpivot the table to the following would do, but I could not quite figure it out.</P><TABLE><TBODY><TR><TD>ID</TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>Cal=(A+C+D)/B</TD></TR><TR><TD>ID1</TD><TD>6</TD><TD>2</TD><TD>3</TD><TD>1</TD><TD>5</TD></TR><TR><TD>ID2</TD><TD>100</TD><TD>40</TD><TD>56</TD><TD>89</TD><TD>6.125</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any helps are greatly appreciated.</P> Tue, 16 Nov 2021 20:43:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-between-rows-with-same-ID/m-p/2193223#M51307 BInovice 2021-11-16T20:43:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-between-rows-with-same-ID/m-p/2193255#M51314 <P>You can easily unpivot in the query editor. Select the Attribute column and under the Transform tab, choose Pivot column.<BR /><BR /></P> <P><img /></P> <P>Then Add Column &gt; Custom Column</P> <P><img /></P> <P>&nbsp;</P> Tue, 16 Nov 2021 21:28:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-between-rows-with-same-ID/m-p/2193255#M51314 AlexisOlson 2021-11-16T21:28:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-between-rows-with-same-ID/m-p/2193293#M51316 <P>Thank you&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="39298" data-lia-user-login="AlexisOlson" class="lia-mention lia-mention-user">AlexisOlson</a>&nbsp;. The solution works magic</P> Tue, 16 Nov 2021 21:56:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-between-rows-with-same-ID/m-p/2193293#M51316 BInovice 2021-11-16T21:56:28Z