Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Rewrite the "if" statement as follows:
if [completionDate] < [slaTargetDate] then true else false
Proud to be a Super User!
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 🙂
I don't think you need "Incidents" before the column names
Rewrite the "if" statement as follows:
if [completionDate] < [slaTargetDate] then true else false
Proud to be a Super User!
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |