Forum Discussion
Need help - DAX
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!
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
3 Replies
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
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