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..."

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.

Not option B Table.Max because it will return the largest row even in that row if a single column has a value zero and other rows have some positive values it would be identified as maximum value and it it is not correct. Question states "identify the maximum values for the numeric columns" Option D is definitely correct for those who are saying it would not add a step check this https://community.fabric.microsoft.com/t5/Community-Blog/Enhanced-Data-Profiling-in-Power-Query-GUI-and-Table-Profile/ba-p/3799762#:~:text=Fortunately%2C%20Power%20Query%20has%20a,step%20%23%22Changed%20Type%22.

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.

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. References = For detailed information on Power Query functions, including Table.Max, please refer to Power Query M function reference.

The good answer is B (Table.Max) : https://learn.microsoft.com/en-us/powerquery-m/table-max

Table.Max

Table.Max because we need only max values as per the question (Table.Profile also gives the result but why we need to run it when we need just max value)

Table profiling is a standard process for analyzing dataset. Anyone working with new dataset would do profiling and answer is D because question is looking for "maximum values for the numeric columns."

Definitely B. A. Table.MaxN: This function finds the top N rows in a table based on a comparison criterion. While it could be used to find a maximum value indirectly, it's less efficient for the task at hand. C. Table.Range: This function creates a list of values within a specified range. It's not directly related to finding maximum values. D. Table.Profile: This provides statistical summaries of columns (min, max, mean, etc.). Using Table.Profile followed by extracting the relevant information would work but is more roundabout than just using Table.Max.