Forum Discussion
Get the Text to work in the query
I am creating an 'IF' Query giving numbers between two values a text outcome but the text causes an error and I don't know why. Can someone please assist me? It's probably a simple fix.
The entire formula worked until I put text in after then.
Could you take a look and see if you know the solution:
IF ([CancelTime] - [StartTime]) >= Time.Minute(10) & ([CancelTime] - [StartTime]) <= Time.Minute (18) then "Yes" else ""
only the "Yes" is failing and I can't seem to resolve it.
I am writing this within the transform data section within 'Custom Column'
You will need to use this query.
1. In PQ, null is used not "" unlike Excel and DAX (though you can use "" also).
2. PQ is super case sensitive
3. For AND condition and is used not &.
= if Duration.TotalMinutes([CancelTime] - [StartTime]) >= 10 and Duration.TotalMinutes([CancelTime] - [StartTime]) <= 18 then "Yes" else null
3 Replies
You will need to use this query.
1. In PQ, null is used not "" unlike Excel and DAX (though you can use "" also).
2. PQ is super case sensitive
3. For AND condition and is used not &.
= if Duration.TotalMinutes([CancelTime] - [StartTime]) >= 10 and Duration.TotalMinutes([CancelTime] - [StartTime]) <= 18 then "Yes" else nullIt worked!
Thanks, Vijay_A_Verma for solving the query! That was very helpful.