PL-300 · Question #300
PL-300 Question #300: Real Exam Question with Answer & Explanation
The correct answer is D: From Power Query Editor, change the distribution for the Column profile to group by length for. From Power Query.. highlight the column.. from the tab view select Column Profile Option.. in the Value distribution section that appears below, from the 3dots.. you can change to group by text length distribution.
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
Explanation
From Power Query.. highlight the column.. from the tab view select Column Profile Option.. in the Value distribution section that appears below, from the 3dots.. you can change to group by text length distribution.
Community Discussion
No community discussion yet for this question.