Which function should you include in the step?

You have a Fabric tenant that contains a warehouse.

You use a dataflow to load a new dataset from OneLake to the warehouse.

You need to add a Power Query step to identify the maximum values for the numeric columns.

Which function should you include in the step?
A . Table. MaxN
B . Table.Max
C . Table.Range
D . Table.Profile

View Answer

Answer: B

Explanation:

The Table.Max function should be used in a Power Query step to identify the maximum values for the numeric columns. This function is designed to calculate the maximum value across each column in a table, which suits the requirement of finding maximum values for numeric columns.

Reference = For detailed information on Power Query functions, including Table.Max, please refer to Power Query M function reference.