New Calculated column based on values from another column

[Nurzh_17]

Hi, 

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. 

Example: 

Table "Document"

Document Number	Document Category
61-2300-P-5090	Master Document
61-2300-P-5090-07812	Project Working Copy
61-2300-P-5090-05908P	Project Working Copy
61-2300-P-5090-05908T1	Project Working Copy
61-2300-P-5090-05908T	Project Working Copy
61-2300-P-5090-07812-21	Project Working Copy

Desired New Column that will identify us the Number of Master Document of this copies: 

Document Number	Document Category	New column (Master Documents)
61-2300-P-5090	Master Document	61-2300-P-5090
61-2300-P-5090-07812	Project Working Copy	61-2300-P-5090
61-2300-P-5090-05908P	Project Working Copy	61-2300-P-5090
61-2300-P-5090-05908T1	Project Working Copy	61-2300-P-5090
61-2300-P-5090-05908T	Project Working Copy	61-2300-P-5090
61-2300-P-5090-07812-21	Project Working Copy	61-2300-P-5090

One more thing is the lenght of Master Documents can be different and we need to check it by Category. 

Thank you for your time! 

[barritown]

Hi @Nurzh_17, 

Please check the solution proposed here:

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-the-text-from-string-and-remove...

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian