Using a list query as parameter file for dynamic table filtering

I need help with being able to use a list query value (reportEndDate) as a parameter (DataPullEnddate) to filter my Dimdate as shown in the M query below. I observed that when the value of rep...

Tips and Tricks

Anonymous

Not applicable

5 years ago

lbendlin

Thank you for your response. A quick solution to the issue would be answered as below:

In this line:

#"Filtered Rows1" = Table.SelectRows(#"Added Custom", each [#"Date:"] >= DataPullStartDate and [#"Date:"] <= DataPullEndDate)

What M query syntax will allow me replace param DataPullStartdate with list value ReportstartDate and param DatapullEndDate with list value ReportEndDate? In that case I wont need the param files after replacing with the list values.

Those list values are from a backend table.

Using paran files does not solve my proble as the list values do not autiomatically populate the param files. I intend to apply those values to dynamically filter my DimDate without having to change the param values in Desktop.

Thank you for your usual quick response.