Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

If Column Contains three 'strings'

Hi all,   Is it possible to create a new column which states IF [Disciplines] =< 3 'Strings' THEN Yes   A string being anything with a , between it.   So Works Manager is one string   Technic...
  • V-lianl-msft's avatar
    6 years ago

    Hi HenryJS ,

     

    You can also try using DAX to create a calculated column.

    Column = IF(SEARCH( "*,*,*", 'Table'[Disciplines], 1, 0 ) > 0,BLANK(),"Yes")

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.