Question
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 Correct
Explanation
Table.Profile returns a profile row for every column of the table, including its minimum, maximum, average, standard deviation, count, null count and distinct count, so one step gives the maximum of each numeric column. Table.Max returns the single row with the largest value according to one comparison criterion, and Table.MaxN returns the top N rows, so neither produces a maximum per column. Table.Range just returns a range of rows by position.
