Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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! | |