topic Create new column with different criteria: SUMIFS in excel in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-column-with-different-criteria-SUMIFS-in-excel/m-p/4166783#M165530 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I would like to add a column using the excel formula: =SUMIFS(sum_range, criteria_range1,criteria1,criteria_range2_criteria2) in power bi.</P><P>&nbsp;</P><P>I need to implement Column D into into power bi (new column).</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR><TD><STRONG>Order Number</STRONG></TD><TD><STRONG>Order Number Line</STRONG></TD><TD><STRONG>Units</STRONG></TD><TD><STRONG>Value</STRONG></TD></TR><TR><TD>A</TD><TD>1</TD><TD>10</TD><TD>55</TD></TR><TR><TD>B</TD><TD>1</TD><TD>27</TD><TD>97</TD></TR><TR><TD>C</TD><TD>1</TD><TD>34</TD><TD>45</TD></TR><TR><TD>B</TD><TD>2</TD><TD>70</TD><TD>97</TD></TR><TR><TD>A</TD><TD>2</TD><TD>45</TD><TD>55</TD></TR><TR><TD>C</TD><TD>2</TD><TD>7</TD><TD>45</TD></TR><TR><TD>C</TD><TD>3</TD><TD>4</TD><TD>45</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In this new column I would like to add the number of total units for each order number (result column D) and to return the result of the sum in each row corresponding to that order number.</P><P>&nbsp;</P><P>Thank you</P> Mon, 23 Sep 2024 09:14:53 GMT usu123ario 2024-09-23T09:14:53Z Create new column with different criteria: SUMIFS in excel https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-column-with-different-criteria-SUMIFS-in-excel/m-p/4166783#M165530 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I would like to add a column using the excel formula: =SUMIFS(sum_range, criteria_range1,criteria1,criteria_range2_criteria2) in power bi.</P><P>&nbsp;</P><P>I need to implement Column D into into power bi (new column).</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR><TD><STRONG>Order Number</STRONG></TD><TD><STRONG>Order Number Line</STRONG></TD><TD><STRONG>Units</STRONG></TD><TD><STRONG>Value</STRONG></TD></TR><TR><TD>A</TD><TD>1</TD><TD>10</TD><TD>55</TD></TR><TR><TD>B</TD><TD>1</TD><TD>27</TD><TD>97</TD></TR><TR><TD>C</TD><TD>1</TD><TD>34</TD><TD>45</TD></TR><TR><TD>B</TD><TD>2</TD><TD>70</TD><TD>97</TD></TR><TR><TD>A</TD><TD>2</TD><TD>45</TD><TD>55</TD></TR><TR><TD>C</TD><TD>2</TD><TD>7</TD><TD>45</TD></TR><TR><TD>C</TD><TD>3</TD><TD>4</TD><TD>45</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In this new column I would like to add the number of total units for each order number (result column D) and to return the result of the sum in each row corresponding to that order number.</P><P>&nbsp;</P><P>Thank you</P> Mon, 23 Sep 2024 09:14:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-column-with-different-criteria-SUMIFS-in-excel/m-p/4166783#M165530 usu123ario 2024-09-23T09:14:53Z Re: Create new column with different criteria: SUMIFS in excel https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-column-with-different-criteria-SUMIFS-in-excel/m-p/4167108#M165544 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="810603" data-lia-user-login="usu123ario" class="lia-mention lia-mention-user">usu123ario</a>&nbsp;,&nbsp;</P><P>&nbsp;</P><P>Pleae use the beloe logic you should be able to get the values you are expecting..</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><EM><U><STRONG>If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!</STRONG></U></EM></P><P>&nbsp;</P><P>Thank You</P><P>Dharmendar S</P><P><A href="https://www.linkedin.com/in/dharmendar-s-b5b43463/" target="_blank" rel="noopener"><SPAN>LinkedIN</SPAN></A><SPAN>&nbsp;</SPAN></P> Mon, 23 Sep 2024 11:27:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-column-with-different-criteria-SUMIFS-in-excel/m-p/4167108#M165544 dharmendars007 2024-09-23T11:27:03Z