Forum Discussion

Sam7's avatar
Sam7
Icon for Advocate II rankAdvocate 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 🙂

     

     

Sam7's avatar
Sam7
Icon for Advocate II rankAdvocate II
4 years ago

Thanks for all your help.  I keep getting an error:

Switch =
SWITCH(
SELECTEDVALUE('Table1'[boolean column])
,TRUE(),"YES",
FALSE(),"NO"
)
 
 
NickolajJessen's avatar
NickolajJessen
Icon for Solution Sage rankSolution Sage
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 🙂