Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
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)
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?
Solved! Go to Solution.
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))
Proud to be a 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))
Proud to be a Super User! | |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
8 | |
7 | |
6 |