Need help - DAX

[Anonymous]

Hi,

Does anyone know how I can create this with DAX code?:

1) Match values from two columns

2) If true, then the matching values should return 5 if they have an activity that starts with PO (from a column) and have a number that starts with 1,2, or 3 from another column. All of these columns are in the same table.

Please help.

Thank you!

[TomMartens · Accepted solution]

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

[Anonymous]

Hi @TomMartens

Thank you so much. Here is my Power BI file. 

https://www.dropbox.com/s/zi7f6cnuvx3j5n2/DAX.pbix?dl=0

[TomMartens]

Hey,

thanks for providing the sample data, but I'm missing a column "expected result" in one of the two tables.

Can you please describe how the formula should work.

Regards,

Tom