Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft DP-600 Exam - Topic 2 Question 45 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 45
Topic #: 2
[All DP-600 Questions]

You have a Microsoft Power BI semantic model that contains a measure named TotalSalesAmount. TotalSalesAmount returns a sales revenue amount that is translated into a selected currency.

You need to ensure that the value returned by TotalSalesAmount is formatted to use the correct currency symbol.

What should you include in the solution?

Show Suggested Answer Hide Answer
Suggested Answer: A

Scenario:

Semantic model contains a measure: TotalSalesAmount.

This measure returns sales revenue translated into a selected currency.

Requirement: Format the result using the correct currency symbol dynamically.

Analysis:

Dynamic format string in DAX is specifically designed for applying formats (like currency symbols) dynamically based on slicers or calculation context.

WINDOW function used for windowing calculations, not formatting.

Linguistic schema used for Q&A natural language, not for formatting.

Field parameter used to swap fields/measures dynamically, not for formatting.

Correct Answer: A. A dynamic format string


Contribute your Thoughts:

0/2000 characters
Ranee
2 days ago
Wait, you mean I can't just use emojis for the currency symbol? Darn, there goes my brilliant plan.
upvoted 0 times
...
Lettie
7 days ago
A field parameter? Sounds like a lot of work for something as simple as a currency symbol.
upvoted 0 times
...
Percy
28 days ago
A linguistic schema? What is this, a language class? I'll pass on that one.
upvoted 0 times
...
Dominga
1 month ago
The WINDOW DAX function? Nah, that's not gonna help with formatting. Stick to the basics, folks.
upvoted 0 times
...
Carey
1 month ago
A dynamic format string is the way to go. Gotta love those fancy currency symbols!
upvoted 0 times
...
Maynard
1 month ago
I’m confused about the WINDOW DAX function; I don’t think it relates to formatting at all, but I might be mixing it up with something else I studied.
upvoted 0 times
...
Keneth
2 months ago
I’m leaning towards option A, the dynamic format string, since it seems to fit the requirement for formatting currency. It just makes sense, right?
upvoted 0 times
...
Blondell
2 months ago
I think I practiced a question similar to this where we had to format measures, and I feel like a linguistic schema was mentioned, but I can't recall the details.
upvoted 0 times
...
Gertude
2 months ago
I remember something about dynamic format strings being used for currency formatting in Power BI, but I'm not entirely sure if that's the right choice here.
upvoted 0 times
...
Melissa
2 months ago
I think a dynamic format string is the way to go here. It allows you to easily adjust the formatting based on the selected currency, which is exactly what the question is asking for.
upvoted 0 times
...
Ma
2 months ago
The WINDOW DAX function doesn't seem relevant to this problem. I'm pretty sure we want to focus on formatting the output, not on any kind of windowing or aggregation. I'd go with option A.
upvoted 0 times
...
Floyd
2 months ago
Based on the question, it sounds like we need to make sure the currency symbol is displayed correctly. I'm leaning towards option A, a dynamic format string, as that seems like the most direct way to handle the formatting.
upvoted 0 times
...
Louvenia
3 months ago
I'm a bit confused on the difference between a dynamic format string and a linguistic schema. Can someone clarify which one would be the best approach for this problem?
upvoted 0 times
...
Louann
3 months ago
Hmm, this seems like a straightforward formatting issue. I think option A, a dynamic format string, is the way to go here.
upvoted 0 times
...

Save Cancel