Value.Multiply

Understanding the Value.Multiply Function

The Value.Multiply function is a simple but powerful function that allows users to multiply two values together. It takes two arguments: Value1 and Value2. The function then multiplies these two values together and returns the result. The syntax for the function is as follows:

Using the Value.Multiply Function in Power Query

The Value.Multiply function can be used in a variety of ways to manipulate data in Power Query. Here are some examples:

Example 1: Multiplying Two Columns Together

Suppose we have a table with two columns, Price and Quantity, and we want to create a new column that calculates the total cost of each item. We can use the Value.Multiply function to do this. Here’s the M code:

This code adds a new column called “TotalCost” to the table and calculates the total cost by multiplying the Price and Quantity columns together.

Example 2: Multiplying a Column by a Fixed Value

Suppose we have a table with a column called “Weight” and we want to convert the values in this column from pounds to kilograms. We know that 1 pound is equal to 0.453592 kilograms. We can use the Value.Multiply function to do this. Here’s the M code:

This code transforms the “Weight” column by multiplying each value by 0.453592 to convert it to kilograms.

Example 3: Multiplying Several Columns Together

Suppose we have a table with three columns, Length, Width, and Height, and we want to calculate the volume of each item. We can use the Value.Multiply function to do this. Here’s the M code:

This code adds a new column called “Volume” to the table and calculates the volume by multiplying the Length, Width, and Height columns together.

The Value.Multiply function is a powerful tool that allows users to multiply two values together in Power Query. It can be used in a variety of ways to manipulate data, including multiplying columns together, multiplying a column by a fixed value, and multiplying several columns together to calculate a new value. By understanding the M code behind this function, users can unlock the full potential of Power Query and take their data manipulation skills to the next level.

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

Upcoming Courses

Contact Us