Forum Discussion
Power BI Desktop - DAX Search text string
Hello,
I created a new Dax column which uses the Search funtion as below:
Search_Version =
SWITCH (
TRUE (),
SEARCH ( "1.8.15", 'D_TT_Historic_Data_Creation_Date'[DESCRIPTION], 1, 0 ) > 0, "1.8.15",
SEARCH ( "1.8.150", 'D_TT_Historic_Data_Creation_Date'[DESCRIPTION], 1, 0 ) > 0, "1.8.150",
SEARCH ( "1.8.16", 'D_TT_Historic_Data_Creation_Date'[DESCRIPTION], 1, 0 ) > 0, "1.8.16",
SEARCH ( "1.8.160", 'D_TT_Historic_Data_Creation_Date'[DESCRIPTION], 1, 0 ) > 0, "1.8.160",
BLANK()
)
However, the search function will not differentiate the text and will show "1.8.15" and "1.8.150" as "1.8.15".
I've been trying to use wildcards like * or ? in different positions but with no success.
So, I'd like to ask your help in how I could adjust this code in order to get exactly the text match.
In case you need any other detail, just let me know.
Thank you
Marcelo
Change the order of the comparisons so that the more selective tests come before the less selective tests
HI datanau001 ,
if you change the order it works.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the solution.
It was exactly what I was looking for.
3 Replies
HI datanau001 ,
if you change the order it works.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the solution.
It was exactly what I was looking for.
Change the order of the comparisons so that the more selective tests come before the less selective tests