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?
To identify the maximum values for numeric columns in Power Query, the Table.Profile function should be used. This function provides statistical summaries of columns, including the maximum values for numeric columns, which directly addresses the requirement. It is more appropriate than Table.Max, which returns the largest row in the table rather than handling multiple columns simultaneously.
D. Table.Profile https://learn.microsoft.com/en-us/powerquery-m/table-profile
you will get summary in that max will include but it doesn't add as power query step so i think it is option b
Table.Max provides only a row with the max value per a single column. We have multiple of columns. It's d
B guys, "you need to add a step..."
Sorry Guys, I changed my mind. It is the letter D.
This is being used in a dataflow. Table.Profile provides a summary of information. You need a specific return for your dataflow not a visual review of the data.
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)
its B , D if u want a summary
IMHO, the answer is B: https://learn.microsoft.com/en-us/powerquery-m/table-max
Sorry, was wrong. Answer id D, because of "for the numeric columns.", not only for one column
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.
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."
Ignore this. Correct answer is B. Since we are interested only in maximum values not all standard profiling columns which includes other functions such as min, count etc., which is not required and slower/expensive too.
Table.Max - https://learn.microsoft.com/en-us/powerquery-m/list-max
https://learn.microsoft.com/en-us/powerquery-m/table-profile
Table.Max
https://learn.microsoft.com/en-us/powerquery-m/table-profile
We should use the `Table.Profile` to identify the maximum values for the numeric columns because only `Table.Profile` returns the maximum values for each column. Note: The `Table.Max` returns the largest row in the table Docs: Table.Profile - https://learn.microsoft.com/en-us/powerquery-m/table-profile Table.Max - https://learn.microsoft.com/en-us/powerquery-m/table-max
B Does not work on multiple columns simultaneously. A t's not specifically used for finding maximum values across all numeric columns, but rather for retrieving a set number of top records C This function is used to retrieve a specific number of rows, starting at a particular index in a table. It's not related to calculating maximum values at all D Using Table.Profile, you can efficiently obtain maximum values along with other statistical insights for each column in your dataset without needing to specify each column manually.
D Table.Profile, just tried it out in Power Query, I am going to use it more in the future ;-)
The good answer is B (Table.Max) : https://learn.microsoft.com/en-us/powerquery-m/table-max
The Syntax is Table.Max(table as table, comparisonCriteria as any, optional default as any) as any the last *as any* after the () is not optional, that's because you should define the column and the output will be row based which means only one row for the defined coulmn While in the the Question (identify the maximum values for the numeric *columns*) which means Table.Profile Answer D is the correct answer
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.