Cube.ApplyParameter

D

Back to top

T

Back to top

#

Back to top

The M Code Behind the Power Query M function Cube.ApplyParameter

Understanding Cube.ApplyParameter

Cube.ApplyParameter is a powerful M function that allows users to pass parameters to a query and apply them to a cube. The function takes two arguments: the cube expression and a record that contains the parameter values. The cube expression is a valid M expression that returns a cube, while the parameter record is a record that contains the parameter values.

The Cube.ApplyParameter function is used to parameterize a query that references a cube. The function enables users to pass parameter values to a cube and apply them to the query. This allows users to create dynamic reports that can be updated based on the parameter values.

How to Use Cube.ApplyParameter

To use Cube.ApplyParameter, you need to create a parameter record that contains the parameter values. The parameter record should be created using the #shared keyword, which is used to define shared values in Power Query. Once you have created the parameter record, you can pass it to the Cube.ApplyParameter function along with the cube expression.

Here is an example of how to use Cube.ApplyParameter:

let

parameterRecord = #shared [

Parameter1 = “Value1”,

Parameter2 = “Value2”

],

cubeExpression = Cube.CubeExpression(“CubeName”),

parameterizedQuery = Cube.ApplyParameter(

cubeExpression,

parameterRecord

)

in

parameterizedQuery

In this example, we first create a parameter record using the #shared keyword. The parameter record contains two parameters: Parameter1 and Parameter2, which have the values "Value1" and "Value2". Next, we create a cube expression using the Cube.CubeExpression function. The function takes the name of the cube as its argument.

Finally, we pass the cube expression and the parameter record to the Cube.ApplyParameter function to create a parameterized query. The parameterized query can be used to create dynamic reports that can be updated based on the parameter values.

Advantages of Using Cube.ApplyParameter

There are several advantages to using Cube.ApplyParameter in Power Query:

1. Dynamic Reports: Cube.ApplyParameter allows users to create dynamic reports that can be updated based on the parameter values. This enables users to create reports that can be easily modified and adapted to changing requirements.

2. Improved Performance: Cube.ApplyParameter can improve the performance of Power Query by reducing the amount of data that needs to be loaded. By applying parameters to a query, users can filter data at the source and reduce the amount of data that needs to be loaded into Power Query.

3. Flexibility: Cube.ApplyParameter provides users with flexibility in how they manipulate and transform data. The function enables users to apply parameters to a wide range of queries and allows them to easily modify and adapt their queries as needed.

Cube.ApplyParameter is a powerful M function that allows users to pass parameters to a query and apply them to a cube. The function enables users to create dynamic reports that can be updated based on the parameter values and provides them with flexibility in how they manipulate and transform data. By using Cube.ApplyParameter, users can improve the performance of Power Query and create reports that can be easily modified and adapted to changing requirements.

Power Query and M Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)