topic Re: New Calculated column based on values from another column in DAX Commands and Tips

topic Re: New Calculated column based on values from another column in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/New-Calculated-column-based-on-values-from-another-column/m-p/3259797#M120497 <P>Hi Anonymous</LI-USER>, </P><P>Please check the solution proposed here:</P><P><A href="https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-the-text-from-string-and-remove-remain-part/m-p/3259782/highlight/true#M120496" target="_blank">https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-the-text-from-string-and-remove-remain-part/m-p/3259782/highlight/true#M120496</A></P><P><STRONG><FONT size="2">Best Regards, </FONT></STRONG></P><P><STRONG><FONT size="2">Alexander</FONT></STRONG></P><P><STRONG><FONT size="2"><A href="https://youtube.com/@powerbi-vlog" target="_blank">My YouTube vlog in English</A></FONT></STRONG></P><P><STRONG><FONT size="2"><A href="https://youtube.com/@pbi-vlog" target="_blank">My YouTube vlog in Russian</A></FONT></STRONG></P> Tue, 30 May 2023 13:59:30 GMT barritown 2023-05-30T13:59:30Z New Calculated column based on values from another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/New-Calculated-column-based-on-values-from-another-column/m-p/3257629#M120354 <P>Hi, </P><P>I need a help with this issue, I would like to create a new column in a table that will show me number of Master Document for Project Copies. </P><P>Example: </P><P>Table "Document"</P><TABLE border="1"><TBODY><TR><TD>Document Number</TD><TD>Document Category</TD></TR><TR><TD>61-2300-P-5090</TD><TD>Master Document </TD></TR><TR><TD>61-2300-P-5090-07812</TD><TD>Project Working Copy </TD></TR><TR><TD>61-2300-P-5090-05908P</TD><TD>Project Working Copy </TD></TR><TR><TD>61-2300-P-5090-05908T1</TD><TD>Project Working Copy </TD></TR><TR><TD>61-2300-P-5090-05908T</TD><TD>Project Working Copy </TD></TR><TR><TD>61-2300-P-5090-07812-21</TD><TD>Project Working Copy </TD></TR></TBODY></TABLE><P><BR />Desired New Column that will identify us the Number of Master Document of this copies: </P><TABLE border="1"><TBODY><TR><TD>Document Number</TD><TD>Document Category</TD><TD>New column (Master Documents)</TD></TR><TR><TD>61-2300-P-5090</TD><TD>Master Document </TD><TD>61-2300-P-5090</TD></TR><TR><TD>61-2300-P-5090-07812</TD><TD>Project Working Copy </TD><TD>61-2300-P-5090</TD></TR><TR><TD>61-2300-P-5090-05908P</TD><TD>Project Working Copy </TD><TD>61-2300-P-5090</TD></TR><TR><TD>61-2300-P-5090-05908T1</TD><TD>Project Working Copy </TD><TD>61-2300-P-5090</TD></TR><TR><TD>61-2300-P-5090-05908T</TD><TD>Project Working Copy </TD><TD>61-2300-P-5090</TD></TR><TR><TD>61-2300-P-5090-07812-21</TD><TD>Project Working Copy </TD><TD>61-2300-P-5090</TD></TR></TBODY></TABLE><P> </P><P>One more thing is the lenght of Master Documents can be different and we need to check it by Category. </P><P> </P><P>Thank you for your time! </P> Mon, 29 May 2023 08:08:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/New-Calculated-column-based-on-values-from-another-column/m-p/3257629#M120354 Anonymous 2023-05-29T08:08:57Z Re: New Calculated column based on values from another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/New-Calculated-column-based-on-values-from-another-column/m-p/3259797#M120497 <P>Hi Anonymous</LI-USER>, </P><P>Please check the solution proposed here:</P><P><A href="https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-the-text-from-string-and-remove-remain-part/m-p/3259782/highlight/true#M120496" target="_blank">https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-the-text-from-string-and-remove-remain-part/m-p/3259782/highlight/true#M120496</A></P><P><STRONG><FONT size="2">Best Regards, </FONT></STRONG></P><P><STRONG><FONT size="2">Alexander</FONT></STRONG></P><P><STRONG><FONT size="2"><A href="https://youtube.com/@powerbi-vlog" target="_blank">My YouTube vlog in English</A></FONT></STRONG></P><P><STRONG><FONT size="2"><A href="https://youtube.com/@pbi-vlog" target="_blank">My YouTube vlog in Russian</A></FONT></STRONG></P> Tue, 30 May 2023 13:59:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/New-Calculated-column-based-on-values-from-another-column/m-p/3259797#M120497 barritown 2023-05-30T13:59:30Z