Forum Discussion

Sam7's avatar
Sam7
Advocate II
4 years ago
Solved

Change Boolean to Wording

UseSwitch = SWITCH(Table1[Column1],TRUE,"Yes",FALSE,"No") I have read lots and seen the above.    I can't get the Table1[Column1] section to work with my tables only my measures.   I want to ch...
Need Help
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    It's telling you, that 'Table1'[Boolean Column] isn't a bool value. 
    Can you check, that it is in fact bool data type?

    Check Power query for Type logical and see if your TRUE, FALSE are italic as so TRUE, FALSE, otherwise it aint bool values 🙂

     

     

NickolajJessen's avatar
NickolajJessen
Solution Sage
4 years ago

Hmm.. Does adding parethesis solve the problem?
ie. TRUE() and FALSE()

EDIT: