From Power BI Desktop, you create a query that imports the following table. You need to configure the table to appear as shown in the following table. What should you do?

The correct answer is B. From the Extract menu, click Text After Delimiter. https://msdn.microsoft.com/en-us/library/mt798301.aspx

Consume and Transform Data by Using Power BI Desktop

Question

From Power BI Desktop, you create a query that imports the following table. You need to configure the table to appear as shown in the following table. What should you do?

Options

AFrom the Extract menu, click Last Characters.
BFrom the Extract menu, click Text After Delimiter.
CFrom the Format menu, click Trim.
DFrom the Split Column menu, click BY Delimiter.

How the community answered

(25 responses)

A
16% (4)
B
72% (18)
C
8% (2)
D
4% (1)

Explanation

https://msdn.microsoft.com/en-us/library/mt798301.aspx

Topics

#Power Query#text transformation#Extract menu#delimiter

Community Discussion

No community discussion yet for this question.

Full 70-778 Practice