Microsoft Power BI Data Analyst — Question 102

You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?

Answer options

• A. In the report, add a DAX calculated column that calculates the length of col1
• B. In the report, add a DAX function that calculates the average length of col1
• C. From Power Query Editor, add a column that calculates the length of col1
• D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

Correct answer: D

Explanation

The correct answer is D because changing the distribution for the Column profile to group by length in Power Query Editor is a method that does not impact the model size. Options A and C would add calculated columns, increasing the model size, while option B only provides an average length rather than the frequency distribution needed.