Providing dynamic date range to PowerQuery

[BobG999999]

I have been looking for a while now, and while I've gotten close, I haven't found that cigar.

I have a PowerQuery gathering transactions from multiple worksheets in a file, and I'd like to be able to filter to get only those transactions with dates between a StartDate and an EndDate. I've gone through several instructions that talk about how to have dynamic filtering, but none that specifically deal with a date range. When I setup some tables per those instructions, I Drilldown to convert the field into text, then go back to my main table and set the filter on the Date field to "between". If I try to edit the M code to use the StartDate and EndDate tables, I get the following error, where "StartDate" and "EndDate" are the single row tables with the desired dates that can be changed.

If I am going about this wrong, I hope someone can let me know and show me how to do it.

 

[GraH]

Set the same data types on the columns you filter and the variables defined. According to the error message it is not the case.
StartDate and EndDate need to be defined as datetime.

 

[BobG999999]

Thanks. That seems to do the trick!

 

[GraH]

Glad I could help. The error message was a giveaway ?. And thanks for the mark.