Question 300 of 388
Single answerYou 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?
✓AIn the report, add a DAX calculated column that calculates the length of col1B.In the report, add a DAX function that calculates the average length of col1C.From Power Query Editor, add a column that calculates the length of col1D.From Power Query Editor, change the distribution for the Column profile to group by length for col1
BAdditional option
✓
Correct Answer: A
In the report, add a DAX calculated column that calculates the length of col1B.In the report, add a DAX function that calculates the average length of col1C.From Power Query Editor, add a column that calculates the length of col1D.From Power Query Editor, change the distribution for the Column profile to group by length for col1
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.