Need help - DAX

Hey,

it would be really helpful, if you create an xlsx file, that contains some sample data, and also a column with the expected result.

Upload the xlsx to onedrive or dropbox and share the link. Providing sample data reduces the effort to create a working solution and also helps to avoid misunderstandings. 

Creating a calculated column you might consider the following DAX functions

• IF https://msdn.microsoft.com/en-us/query-bi/dax/if-function-dax
• LEN https://msdn.microsoft.com/en-us/query-bi/dax/len-function-dax
• FIND https://msdn.microsoft.com/en-us/query-bi/dax/find-function-dax or
• SEARCH https://msdn.microsoft.com/en-us/query-bi/dax/search-function-dax
• LEFT https://msdn.microsoft.com/en-us/query-bi/dax/left-function-dax

Check if the length of both column equals if the value of column 1 is in column 2, if this is the case check if the first 2 characters are PO ...

Hopefully this gets you started.

Regards,

Tom