Microsoft Discussions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Go to Exam

Exam 70-778 topic 1 question 43 discussion

Actual exam question from Microsoft's 70-778

Question #: 43
Topic #: 1

[All 70-778 Questions]

DRAG DROP -
You have a customer table in Power BI Desktop. The customer table contains the columns as shown in the following table.

You need to create a custom column that hides the first three digits of the SSN. The values in the new column must have the xxx-99-9999 format.
How should you complete the Query Editor formula? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

References:
https://msdn.microsoft.com/query-bi/m/text-replace
https://msdn.microsoft.com/en-us/query-bi/m/text-start

by r8d1 at July 3, 2020, 12:39 p.m.

Comments

Submit Cancel

CDL

4 years, 7 months ago

texted, correct answer. --> Text.Replace([SSN],Text.Start([SSN],4), "xxx-")

upvoted 1 times

...

da_boston

4 years, 8 months ago

I successfully reproduced using first: "Text.Replace" then "Test.Start"

upvoted 3 times

...

r8d1

4 years, 11 months ago

sneaky, that '4' and 'xxx-' are used, just to throw the reader off. :-P

upvoted 1 times

cromastro

4 years, 9 months ago

No. That's not correct. The Text.Replace takes three arguments. 1) [SSN] 2) Text.Start(first four characters of SSN) 3) replace with "xxx-"

upvoted 1 times

...

...