Forum Discussion

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

IF Contains Text

Hi all,   How do I create a new column IF Ref 1 has text then Yes     Thanks,   H
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    HenryJS 

     

    Column = IF(ISBLANK([Ref 1]),BLANK(),"Yes")

     


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

AnkitBI's avatar
AnkitBI
Icon for Solution Sage rankSolution Sage
6 years ago

Hi HenryJS 

 

Try using ISTEXT function available in DAX. If you are looking for PQ, let me know.

 

Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.