Microsoft
PL-300 · Question #300
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 sol
Sign in or unlock PL-300 to reveal the answer and full explanation for question #300. The question stem and answer options stay visible for context.
Submitted by khalil_dz· Apr 18, 2026
Question
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?
Options
- AIn the report, add a DAX calculated column that calculates the length of col1
- BIn the report, add a DAX function that calculates the average length of col1
- CFrom Power Query Editor, add a column that calculates the length of col1
- DFrom Power Query Editor, change the distribution for the Column profile to group by length for
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.