Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Query if Date between

Hello,  I'm not very good to Power Query and I don't know why it doesn't work :  if [Order created] >= 2022-01-01 & [Order created] <= 2022-12-31 then 1 else 0   Thank you for your help
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    if[Date] >= #date(2022,01,01) and [Date] <= #date(2022,12,31)then 1 else 0

Anonymous's avatar
Anonymous
Not applicable
4 years ago

This didn't work for me, 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) and Time.Minute (18) then "Yes" else ""

 

only the "Yes" is failing and I can't seem to resolve it.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Without seeing the data it's difficult to give a correct answer. If you keep the calculation within one set of brackets maybe it will work?