Forum Discussion

tijuemson's avatar
tijuemson
Frequent Visitor
5 years ago
Solved

return Yes or no from column

Download data here    So i am in a pickle i have to find certain customers from a survey results if they fill anything like sucidal or self harm and i need to flag it.   so i used containsstring...
Data Protection
Need Help
Tips and Tricks
Tutorial Requests
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi tijuemson 

    This Measure will work, but you haven't provided actual data to test against.

     

    Measure = MAX('Table'[Column1])

     

    Doing a MAX on a text column will return "True" if it exists anywhere, otherwise you will get "False".  T comes after F in the alphabet.  This is assuming the column can only contain "True"or "False" as you described.

    Regards

    Phil

tijuemson's avatar
tijuemson
Frequent Visitor
5 years ago

Hi Phil thanks for the help

i just converted the red alert one(which was in true/false) to Text and it works now

 

thank you so much