PowerQuery - Check if Column value equals true

Question

I have build several additional columns in PowerQuery based on my source data. This includes two "TextContains" columns which only return "TRUE" or "FALSE". I now want an additional Column highlighting the different service types and used this:

if [PSTag] = "PS" then "PS" 
else if [Trainingskit] = "TrainingsKit" then "Training"
else if [Training] = "Training" then "Training"
else if [HardwareService] = "TRUE" then "HardwareService"
else if [TelephoneService] = "TRUE" then "TelephoneService" else "NonService"

It works fine for the first three IF statements, but doesn't work at all for the Columns containing only "TRUE" or "FALSE". The first three contain either e.g. "PS" or "NonPS" or "Training" or "NonTraining"

I'm sure I'm "just" missing a very fundamental here.

Any help is highly appreciated.

Answer 1

Columns containing only TRUE or FALSE are likely the "True/False" datatype. Their values appear in italic font in the Query Preview window.

If that is the case with your [HardwareService] and [TelephoneService] columns then I would remove the quotes e.g. write something like:

... if [HardwareService] = true then ...