Get the Text to work in the query

[Anonymous]

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'

[watkinnc]

You are trying to transform a time or number to text. I would use them true else false, then change to text later.

--Nate

[Vijay_A_Verma · Accepted solution]

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

[Anonymous]

It worked!

Thanks, @Vijay_A_Verma for solving the query! That was very helpful.