BenchMark Quizzes by MDFT Pro

Find Maximum Values In Numeric Columns

You work as a data analyst at MDFT Pro, a well-known training agency. The academy has a Fabric tenant that contains student assessment data in a warehouse. You use a dataflow to load new assessment results from OneLake to the warehouse.

You need to add a Power Query step to identify the maximum scores for all numeric columns in the dataset. Which function should you include in the step?

Choose the correct answer from the options below.

Explanations for each answer:

Table.MaxN is incorrect. Table.MaxN returns a specified number of rows with the highest values in a given column, but does not identify maximum values across all numeric columns
Table.Max is incorrect. Table.Max returns the maximum value from a single column, but cannot analyze multiple numeric columns simultaneously
Table.Range is incorrect. Table.Range returns a subset of rows from a table based on starting position and count, and is not used for statistical analysis
Table.Profile is correct.

Learn more about the Table.Profile function:

Table.Profile Function

Practice Exam

Find Maximum Values In Numeric Columns

Discuss this question on social media: