Forum Discussion

HenryJS's avatar
HenryJS
Post 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.

4 Replies

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    IF(Reference1 <> BLANK(), "Yes", "No"

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.