Forum Discussion
How to create a filter that controls the DirectQuery directly?
You can either hand over a date range to the parameter (and handle that in your Power Query code) or use separate tables for the Start and End date ranges. I would suggest the first option.
Here is one possible implementation Chris Webb's BI Blog: Handling Multi-select In Power BI Dynamic M Parameters (crossjoin.co.uk)
I already have separate tables for the Start and End date ranges as it looks in the first picture of my last reply. My question is that if I hand over a date range to the parameter, will the Start and End dates be selected as two individual dates or will it take all the dates between the two.
Example:
Selecting Start date= 1/1/2024
Selecting End Date = 6/1/2024
will it only show me dates from 1/1/2024 and 6/1/2024 or will it give me all the data points from 1/1/2024-6/1/2024. I would need it to get all data points from 1/1/2024-6/1/2024.