Exam DP-600 topic 1 question 14 discussion

D. Table.Profile https://learn.microsoft.com/en-us/powerquery-m/table-profile

B guys, "you need to add a step..."

I initially thought that the right answer was B, but the question must be answered: “You need to add a PowerQuery step to identify the maximum values of numeric columns.” Table.Max although it can find the maximum value, it is used for a single column and returns a single row based on one column. It doesn't work for several numeric columns at once.

D. Table.Profile

Table.Max: The Table.Max function returns the maximum value for a specified column in a table. It is the correct function to use when you need to identify the maximum value for numeric columns.

Correct Answer: B. Table.Max Explanation: Table.Max is the appropriate function to use when you need to identify the maximum value in a specific column. You can apply this function to each numeric column in your dataset to find the maximum values. Why Other Options Are Incorrect: A. Table.MaxN: This function is used to get the top N rows, not the maximum value in a column. C. Table.Range: This function is used to select a range of rows, not to find maximum values. D. Table.Profile: While this function provides a summary of the data, including maximum values, it does not allow you to extract or use these maximum values directly in subsequent steps.

Chose D as it's looking for multiple numeric columns not a single one

D Table.Profile: This function provides a statistical summary of a table, including the maximum values for numeric columns, along with other statistics like minimum, average, and count. It is specifically designed to give an overview of the dataset, making it ideal for identifying maximum values for numeric columns. Table.MaxN: Returns the top N rows based on a specified column but does not specifically identify the maximum value across numeric columns. Table.Max: Returns a single row with the maximum value for a specified column but does not provide maximum values for all numeric columns.

The correct answer is B. Table.Max. Explanation: Table.Max: This function is specifically designed to calculate the maximum value within a column of a table. It's the most suitable choice for identifying the maximum values for numeric columns in your PowerQuery step. Table.MaxN: This function returns the top N rows of a table. It's not appropriate for calculating maximum values. Table.Range: This function creates a new table containing a range of rows from an existing table. It's not relevant to finding maximum values. Table.Profile: This function provides statistical information about a table, including measures of central tendency and dispersion. While it can be useful for understanding data, it's not the most direct way to find maximum values. By using Table.Max in your PowerQuery step, you can efficiently identify the maximum values for the numeric columns in your dataset, enabling further analysis and decision-making.

it says columnS, so it is D

I think it's D.

Table.Profile

Option D, Table.Profile, returns all kind of aggregate values for *all* columns. Including the max values. It adds a step to PowerQuery; it is written in M, you're not watching it as part of the Power BI interface. I was convinced it was B, but not that it is TABLE.Max, not List.Max. That is an important difference. This function does the following: "Returns the largest row in the table, given the comparisonCriteria." So you get one row of data, not the list of values you want. Reference: https://learn.microsoft.com/en-us/powerquery-m/table-profile https://learn.microsoft.com/en-us/powerquery-m/table-max

Table.Profile gives Min,Max,Average,StandardDeviation,Count,NullCount,DistinctCount for all columns Table.Profile(#"last step name") Table.Max gives only the maximum value for the specified column(entire row of the maximum value column) Table.Max(#"last step name","column name")

I vote D too. The ask is for maximum value for numeric columnS. Note plural. Table.MaxN and Table.Max will return entire row(s) with max value for a specific column (singlular) so they are out. Table.Profile returns the following stats for all columns where applicable:- minimum maximum average standard deviation count null count distinct count so that fits the bill.

A & C Incorrect, other logic D -> Will not add another power query step, will only display B it is

The reason why Table.Max is not the correct choice is that Table.Max returns the row in a table that contains the maximum value for a specified column, rather than providing the maximum values for all numeric columns.