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.

View Answer

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