
Answer-first summary for fast verification
Answer: Table.Profile
The Table.Profile function provides an overview of the data in a table, including basic statistics like count, average, null count, distinct count, and standard deviation for numerical columns. This makes it the appropriate function to use in order to display the specified column statistics.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are working within a Fabric tenant that includes a Microsoft Power BI report, and you are in the process of exploring a new semantic model. In order to gain insights from your data, you are required to display specific column statistics. The statistics you need to display are: Count, Average, Null count, Distinct count, and Standard deviation. Which Power Query function should you execute to obtain these statistics?
A
Table.schema
B
Table.view
C
Table.FuzzyGroup
D
Table.Profile
No comments yet.