Forum Discussion
Boolean puzzle in Power Query
I can't believe this is not working for me..... I am creating a new column in Power Query as follows: = Table.AddColumn(#"Removed Columns", "StpsInclude", each if [OrganisationID] = 29 then f...
- Hi Anonymous
A true or false column is a bolean value as you say so on query editor you need change your true pr false by 1 or 0 then convert it to true or false should work.
Regards
MFelix Or you can convert it to type logical (instead of type binary).
BTW: You can omit the condition in your statement. Just write
Table.AddColumn(#"Removed Columns", "StpsInclude", each [OrganisationID] = 29)
and true and false will be created automagically ;)
Or you can convert it to type logical (instead of type binary).
BTW: You can omit the condition in your statement. Just write
Table.AddColumn(#"Removed Columns", "StpsInclude", each [OrganisationID] = 29)
and true and false will be created automagically ;)