Restrict Power Query Data

[bdehning]

I have a Table Data Source that I coonect to on a Server.  This table has data in my Calender Year Column going back to 1950.  

How do I restrict rows of data for Calendar Year to be after 1/1/2010 in the table?

[Idrissshatila · Accepted solution]

Hello,

You can filter by date/time value using the Date/Time Filters submenu.

To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.

Select the down arrow 

 of the column containing a date/time value by which you want to filter.

Select Date/Time Filters, and then select an equality type name of Equals, Before, After, Between, In the Next, In the Previous, Is Earliest, Is Latest, Is Not Earliest, Is Not Latest, and Custom Filter.

If I answered your question, please mark the solution as solved, appreciate your kudos👍