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
Estrella
18 days ago
C is not relevant here. We need formatting, not linguistics.
upvoted 0 times
...
Luz
23 days ago
B seems interesting, but it doesn't address formatting directly.
upvoted 0 times
...
Reena
29 days ago
Agreed! A allows for real-time currency changes.
upvoted 0 times
...
Vonda
1 month ago
I think A is the best choice. Dynamic format strings are flexible.
upvoted 0 times
...
Arlene
1 month ago
Surprised this isn't more straightforward!
upvoted 0 times
...
Glory
1 month ago
Wait, can a field parameter actually do that?
upvoted 0 times
...
Stephane
2 months ago
I thought the WINDOW DAX function could help too?
upvoted 0 times
...
Raina
2 months ago
Totally agree, it makes sense for currency formatting.
upvoted 0 times
...
Toi
2 months ago
A dynamic format string is the way to go!
upvoted 0 times
...
Ranee
2 months ago
Wait, you mean I can't just use emojis for the currency symbol? Darn, there goes my brilliant plan.
upvoted 0 times
...
Lettie
2 months ago
A field parameter? Sounds like a lot of work for something as simple as a currency symbol.
upvoted 0 times
...
Percy
3 months ago
A linguistic schema? What is this, a language class? I'll pass on that one.
upvoted 0 times
...
Dominga
3 months ago
The WINDOW DAX function? Nah, that's not gonna help with formatting. Stick to the basics, folks.
upvoted 0 times
...
Carey
3 months ago
A dynamic format string is the way to go. Gotta love those fancy currency symbols!
upvoted 0 times
...
Maynard
4 months 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
4 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
4 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
4 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
4 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
4 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
5 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
5 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
5 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
Fletcher
13 days ago
I agree, a dynamic format string makes sense for currency.
upvoted 0 times
...
...

Save Cancel