Power Query Date Column filtering greater than or equal to date in Excel cell

[GRCArizona]

Hi - I've relatively new to Power Query and I can't seem to find out how to accomplish this. I've got a date in a cell (start of our Fiscal Year). I'm trying to filter a column of data in Power Query that is greater than or equal to the Fiscal Year date in the excel cell. I've created a table in excel with the Fiscal Date and brought it over to Power Query ("tbl_Start_Date"). My M Code is:

=Table.SelectRows(#"Expanded Table Column1", each [Policy Start Date] >=(tbl_Start_Date))

but I'm getting an Expression.Error: We cannot apply operator < to types DateTime and Date.

It works perfect if I only use "=" and get rid of the greater than portion.

I've searched for about an hour now and can't seem to find where anyone else has asked this.

Any help is greatly appreciated!

thanks
GRC

 

[Automatrix]

You can do a helper column that is just equal to the fiscal date. Then it's a conditional column that compares the two (make sure they have the same data type).

 

[GRCArizona]

That worked! Thanks! Just surprised it isn't easier (as far as I can tell...) to use >=.

Seems like the more I learn this stuff, I realize I don't know very much...

Thanks again!

 

[GraH]

The error message simply points out you cannot compare fields of type datetime with fields of type date. Both fields should be the same.
Then the set-up will work. No need to duplicate anything. As a rule of thumb never add columns to PQ if you can avoid it as it makes it run slower. At least that is my experience.

Table.SelectRows(#"Expanded Table Column1", each DateTime.Date([Policy Start Date]) >=tbl_Start_Date )

or

Table.SelectRows(#"Expanded Table Column1", each [Policy Start Date] >=DateTime.Date( tbl_Start_Date) )

depending on which field is actually a datetime field.