Custom Filter menu option for a column is missing

[WorkHard]

I'm trying to setup incremental update and I'm trying to define the RangeStart and RangeEnd.

To do that, I need to set a custom filter on my date column but that option doesn't exist.

My date column is exactly the same as in the below example, the data type is "date/time".

When I right-click on the column, I  have much less options and the Custom filter on my end only allows a date, not a parameter.

How do I get to this?

[az38]

Hi @WorkHard 

if I understand you correct you are lookint at two different modes:

extend filters are available at Power Query editor mod and not available in Data view

[jdbuchanan71 · Accepted solution]

@WorkHard 

That filter view is in the query editor (PowerQuery) rather than in the table view.  If you right click on your table and go to 'Edit Query' then select the filter drop down on the date column and go to Date Filters you will see the bigger list of options.

[WorkHard]

Duh, thank you. I figured I'm overthinking it.