topic DAX increate a column grouping for a column and providing the data for other in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-increate-a-column-grouping-for-a-column-and-providing-the/m-p/2732275#M83694 <P>I am trying to create a new column in DAX that will give the result of the column Status for the type “Chain” with records with the same ID.&nbsp; For example, for this table</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>Name</P></TD><TD><P><STRONG>Type</STRONG></P></TD><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Status</STRONG></P></TD></TR><TR><TD><P>a</P></TD><TD><P>Chain</P></TD><TD><P>21</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>b</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>c</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>d</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>e</P></TD><TD><P>Chain</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>f</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>g</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>h</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The result will be</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>Name</P></TD><TD><P><STRONG>Type</STRONG></P></TD><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Status</STRONG></P></TD><TD><P><STRONG>NewChain Status</STRONG></P></TD></TR><TR><TD><P>a</P></TD><TD><P>Chain</P></TD><TD><P>21</P></TD><TD><P>Open</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>b</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Closed</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>c</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Closed</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>d</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Open</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>e</P></TD><TD><P>Chain</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>f</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>g</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>h</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD><TD><P>Closed</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can you help me?</P> Mon, 29 Aug 2022 10:14:42 GMT vzbkb1 2022-08-29T10:14:42Z DAX increate a column grouping for a column and providing the data for other https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-increate-a-column-grouping-for-a-column-and-providing-the/m-p/2732275#M83694 <P>I am trying to create a new column in DAX that will give the result of the column Status for the type “Chain” with records with the same ID.&nbsp; For example, for this table</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>Name</P></TD><TD><P><STRONG>Type</STRONG></P></TD><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Status</STRONG></P></TD></TR><TR><TD><P>a</P></TD><TD><P>Chain</P></TD><TD><P>21</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>b</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>c</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>d</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>e</P></TD><TD><P>Chain</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>f</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>g</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>h</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The result will be</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>Name</P></TD><TD><P><STRONG>Type</STRONG></P></TD><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Status</STRONG></P></TD><TD><P><STRONG>NewChain Status</STRONG></P></TD></TR><TR><TD><P>a</P></TD><TD><P>Chain</P></TD><TD><P>21</P></TD><TD><P>Open</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>b</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Closed</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>c</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Closed</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>d</P></TD><TD><P>Job</P></TD><TD><P>21</P></TD><TD><P>Open</P></TD><TD><P>Open</P></TD></TR><TR><TD><P>e</P></TD><TD><P>Chain</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>f</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>g</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD><TD><P>Closed</P></TD></TR><TR><TD><P>h</P></TD><TD><P>Job</P></TD><TD><P>22</P></TD><TD><P>Closed</P></TD><TD><P>Closed</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can you help me?</P> Mon, 29 Aug 2022 10:14:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-increate-a-column-grouping-for-a-column-and-providing-the/m-p/2732275#M83694 vzbkb1 2022-08-29T10:14:42Z Re: DAX increate a column grouping for a column and providing the data for other https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-increate-a-column-grouping-for-a-column-and-providing-the/m-p/2732293#M83696 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="301823" data-lia-user-login="vzbkb1" class="lia-mention lia-mention-user">vzbkb1</a>&nbsp;<BR />Please try</P> <LI-CODE lang="javascript">NewChain Status = MAXX ( FILTER ( CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[ID] ) ), TableName[Type] = "Chain" ), Chain[Status] )</LI-CODE> Mon, 29 Aug 2022 10:24:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-increate-a-column-grouping-for-a-column-and-providing-the/m-p/2732293#M83696 tamerj1 2022-08-29T10:24:26Z Re: DAX increate a column grouping for a column and providing the data for other https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-increate-a-column-grouping-for-a-column-and-providing-the/m-p/2733004#M83741 <P>Thanks a lot it works great <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 29 Aug 2022 15:44:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-increate-a-column-grouping-for-a-column-and-providing-the/m-p/2733004#M83741 vzbkb1 2022-08-29T15:44:00Z