Forum Discussion
Apply where condition in Power Query
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
Hello,
if your column is formatted as date you can apply date filter via the little arrow in the right of your heading row.
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
2 Replies
Hello,
if your column is formatted as date you can apply date filter via the little arrow in the right of your heading row.
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