How to enter a formula to check if time was before 11am

[mp390988]

Hi,

I am entering this formula in a custom column inside power query editor:

What am I doing wrong please?

Thanks

[SundarRaj · Accepted solution]

Hi @mp390988 , the if you wrap around the "11:00:00" in TimeFromText(), it should work. Thanks!

Code:
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type datetime}, {"Time", type time}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if [Time] >= Time.FromText("11:00:00") then "Yes" else "No")
in
#"Added Custom"

[Vijay_A_Verma · Accepted solution]

In your formula, replace 11:00:00 with #time(11, 0, 0)

or Time.FromText("11")

[SundarRaj · Accepted solution]

Hi @mp390988 , the if you wrap around the "11:00:00" in TimeFromText(), it should work. Thanks!

Code:
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type datetime}, {"Time", type time}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if [Time] >= Time.FromText("11:00:00") then "Yes" else "No")
in
#"Added Custom"