Power Query | In between two times

[ovetteabejuela]

Hi,

I think this is a very simple question to answer (probably why I can't find anything on the web) so I'm asking:

I want to check if a DateTime is in between 2 DateTimes

if DateTime(C) >= DateTime(A) or DateTime(C) <= DateTime(B) then 1 or 0

How do you do that in Power Query?

[Anonymous · Accepted solution]

HI @ovetteabejuela,

You can add custom column in power query with if statement.

Sample:

    #"Added Custom" = Table.AddColumn(#"Previous step", "Custom", each if [C] >= [A] or [C] <= [B] then 1 else 0)

Regards,

Xiaoxin Sheng

[edhans]

If they are in different columns, just reference the columns. If not, and you want to directly references the datetime, use the #datetime() function.

There is also a #date() function that is just #date(y,m,d)