Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
DAMyers
New Member

Power Query Excel filter rows using start and end date from cell values in spreadsheet

I have a power query from SQL database to an Excel workbook. I need to filter the query rows using a start and end date from cells in the workbooks. I created the cells with values 5/1/2025 for start date and 5/31/2025 for end date. I then selected the start date cells and selected and created a query using Data==>Get Data from Table/Range. This created a Power Query named StartDate. I did the same for EndDate value resulting in query End date.

DAMyers_0-1747757680970.pngDAMyers_1-1747757744055.png

 

 

 

I am attempting to filter rows in my main query using these two query values. When I alter the main query filter rows code like this:

= Table.SelectRows(#"Filtered Rows3", each [SAMPLED_DATE] >= StartDate and [SAMPLED_DATE] <= EndDate)

DAMyers_2-1747757900143.png

 

I get this error:

Expression.Error: We cannot apply operator < to types Table and DateTime.
Details:
Operator=<
Left=[Table]
Right=5/8/2025 11:02:25 AM

 

I have checked and the data type for [SAMPLED_DATE], StartDate, and EndDate are all Date/Time. What am I missing?

1 ACCEPTED SOLUTION
jgeddes
Super User
Super User

It looks like your 'Start Date' and 'End Date' references are tables. You may want to look at using Table.FirstValue(). Something like the following might work for you.

Table.SelectRows(#"Filtered Rows3", each [SAMPLED_DATE] >= Table.FirstValue(StartDate) and [SAMPLED_DATE] <= Table.FirstValue(EndDate))

  





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
jgeddes
Super User
Super User

It looks like your 'Start Date' and 'End Date' references are tables. You may want to look at using Table.FirstValue(). Something like the following might work for you.

Table.SelectRows(#"Filtered Rows3", each [SAMPLED_DATE] >= Table.FirstValue(StartDate) and [SAMPLED_DATE] <= Table.FirstValue(EndDate))

  





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors