Need help adding a calculated column

[JortBreij]

I want to add another column in my table with true or false.

It's really simple I thought. This is what I had in power query editor:

= Table.AddColumn(Incidents_table, "SlaBehaald",
each if(
Incidents[completionDate] < Incidents[slaTargetDate],
true,
false
))

So if the completiondate is earlier then the slaTargetDate, then it should be true, otherwise false.

Instead is shows the token rightparen expected error.

[AndrewDavies]

Your formula would work in DAX but power query uses M language. If you want to write an if statement then the syntax would be:

if [completionDate] < [slaTargetDate] then true else false

Make sure the "if" is all lowercase. Hope this helps 🙂 

[johnt75]

I don't think you need "Incidents" before the column names

[DataInsights · Accepted solution]

@JortBreij,

Rewrite the "if" statement as follows:

if [completionDate] < [slaTargetDate] then true else false