QuestionQ46

VerifiedPrepare data

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 PowerQuery step to identify the maximum values for the numeric columns.

Which function should you include in the step?

Explanation

Table.Profile generates statistical summaries (min, max, average, count, standard deviation) for all columns in a single operation, making it ideal for identifying maximum values across multiple numeric columns simultaneously. Table.Max operates on individual columns and returns a single row. Table.Range selects row ranges, and Table.MaxN retrieves top rows—neither provides the aggregate statistics needed.

Community Discussion

No comments yet. Be the first to start the discussion!