Dynamic M query parameters

[maneschr2022]

Hi, does anyone have a pbix file to show me an example on how to reference in M query a dynamic M parameter to filter data based on Month-Year field?,

I have a datetime field, which I need to transform to Month-Year format, then I want to use it as a parameter so users are able to select a particular Month-Year in the slicer to display the data.

[ppm1]

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

[maneschr2022 · Accepted solution]

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

[mgtaylor33]

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?

[maneschr2022]

@Syndicate_Admin is ADX

[Syndicate_Admin]

What is your data source?  SQL server table?