Forum Discussion
datanau001
3 years agoHelper III
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....
- 3 years ago
Change the order of the comparisons so that the more selective tests come before the less selective tests
- 3 years ago
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.
- 3 years ago
Thank you for the solution.
It was exactly what I was looking for.
mangaus1111
3 years agoSolution Sage
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.
- datanau0013 years agoHelper III
Thank you for the solution.
It was exactly what I was looking for.