Apply where condition in Power Query

[Narender]

Hi Team,

Hi Team,

I want to show only those data of a table whose Year>2015.

Actually i have huge years data , I want to use limited year  data. So i want to apply condition like Show the table where Year>2015.

Please let me know how i can achieve this in Power Query.

Thanks,

Narender

[Floriankx · Accepted solution]

Hello,

if your column is formatted as date you can apply date filter via the little arrow in the right of your heading row.

[v-yuta-msft · Accepted solution]

Hi Narender,

Follow steps below:

1.Click Query Editor-> select the column you want to filter with->select number filters like below:

  

2.Select a filter type and then set filter.

 

3.The result is like this.

  

Hope it's helpful to you.

Regards,

Jimmy Tao

[Floriankx · Accepted solution]

Hello,

if your column is formatted as date you can apply date filter via the little arrow in the right of your heading row.