Forum Discussion
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...
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 🙂
Hmm.. Does adding parethesis solve the problem?
ie. TRUE() and FALSE()
EDIT:
How does the formula look like?