Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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
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
Hello,
if your column is formatted as date you can apply date filter via the little arrow in the right of your heading row.