Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Search logic

DEDF or GENERAL = IF( SEARCH("DTL",Query1[HAULIER]),"Dedicated","General")

 

Is there a reason why im getting the error. Is it because im trying to search something that contains "DTL" rather than is exactly "DTL", i.e some are DTLB, DTLD etc etc.

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous

    Write your DAX in this way

                 DEDF or GENERAL = IF(SEARCH("DTL",Query1[HAULIER],1,FALSE()),"Dedicated","General")

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous

    Write your DAX in this way

                 DEDF or GENERAL = IF(SEARCH("DTL",Query1[HAULIER],1,FALSE()),"Dedicated","General")