Forum Discussion
Solved
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...
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))
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))