How should you complete the Query Editor formula?

HOTSPOT

You have a table that contains a column named Phone.

The following is a sample of the data in the Phone column.

You need to add a new column that contains the data in the format of nnn-nnn-nnnn.

How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Text

Description automatically generated

References: https://docs.microsoft.com/en-us/powerquery-m/text-replace

https://docs.microsoft.com/en-us/powerquery-m/text-end

Latest PL-300 Dumps Valid Version with 131 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments