Forum Discussion

datanau001's avatar
datanau001
Helper III
3 years ago
Solved

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....
  • HotChilli's avatar
    3 years ago

    Change the order of the comparisons so that the more selective tests come before the less selective tests

  • mangaus1111's avatar
    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.

  • datanau001's avatar
    datanau001
    3 years ago

    Thank you for the solution.

    It was exactly what I was looking for.