How i can apply where clause in Power Qwery

[Narender]

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

[v-qiuyu-msft · Accepted solution]

Hi @Narender,

You can go to Query Editor, find the year column, then click drop down to select Numer Filters: 

The corresponding Power Query will be generated via above action:

Best Regards,
Qiuyun Yu