MPARAMETER DAX Statement
The MPARAMETER keyword defines the value of a parameter used in Power Query for a dynamic M parameter in DirectQuery connections.
The name corresponds to the parameter name defined in the Power Query Editor; if the M parameter name contains a space, it should be surrounded by single quotes.
The following example shows different types of dynamic M parameters for a single DAX query.
DEFINE // Single date parameter MPARAMETER DateParameter = DATE ( 2022, 5, 23 ) // Single string parameter, where the parameter name includes a space MPARAMETER 'Country Parameter' = "Canada" // Multi-select enabled on dynamic M parameter MPARAMETER BrandParameter = { "Contoso", "Fabrikam" } EVALUATE SUMMARIZECOLUMNS ( 'Date'[Date], "Sales", [Sales Amount] )
Last update: Sep 29, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters