Forum Discussion
Dynamic M query parameters
Yes I needed M dynamic query for better performance, but I resolved the question by myself using Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
If your direct query table doesn't have a column with values that match the ones in your YearMonth slicer, it isn't as straight forward. Two options:
1. Are you sure you need Dynamic M parameters? If you have a Date table with a relationship to your DQ table, your visual should create a query that includes the date values in that YearMonth.
2. In the query editor, you'll have to create min and max date values from your selected text YearMonth value. You can then filter your query by the min and max dates.
Pat
Yes I needed M dynamic query for better performance, but I resolved the question by myself using Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Hi, I'm looking for a solution here also, Issue I have is the sendign a a date Parameter, when you managed to solve your issue did you happen to use a date parameter, would b goo dto see how you got that to work. I am direct Query-ing Snowflake, I have made a data parameter I have made a filter to use for the parameter, but cannot seem to attch( Bind) it all together and get the correct date format. Any help you can give here?
