IF Contains Text

[HenryJS]

Hi all,

How do I create a new column IF Ref 1 has text then Yes

Thanks,

H

[Anonymous · Accepted solution]

@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.

[FrankAT]

 Regards Frank AT

[Anonymous]

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

[AnkitBI]

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.