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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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?