Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to 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👍
Proud to be a Super User! | |
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👍
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
39 | |
27 | |
27 |
User | Count |
---|---|
97 | |
97 | |
58 | |
45 | |
42 |