Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 90 discussion

Actual exam question from Microsoft's PL-300
Question #: 90
Topic #: 2
[All PL-300 Questions]

HOTSPOT
-

You have a Power BI semantic model that contains a table named Opportunity.

The Opportunity table contains a column named Qualification. The Qualification column contains values between 0 and 1.

You need to build a new measure to score the opportunities on a scale of low. medium, and high.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by Endeetheanalyst at Sept. 5, 2024, 1:21 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
P_BKTX
Highly Voted 2 months, 1 week ago
IF is correct answer https://learn.microsoft.com/en-us/dax/if-function-dax check last example
upvoted 5 times
1CY1
2 months ago
I'm going with just 'IF'. IF.Eager seems to only be required for variant data type comparison... The IF.EAGER function can return a variant data type if value_if_true and value_if_false are of different data types, but the function attempts to return a single data type if both value_if_true and value_if_false are of numeric data types. In the latter case, the IF.EAGER function will implicitly convert data types to accommodate both values.
upvoted 1 times
...
...
jaume
Most Recent 1 day, 5 hours ago
I would vote for the IF not IF.EAGER as I cannot see the point to use second one. Then HIGH & MEDIUM
upvoted 1 times
...
miloszmiloszz
2 months ago
I will use IF instead of IF.EAGER due to values that are used in true/false arguments. If there would be more complex values (another formulas, references to columns etc.) I will prefer IF.EAGER. See https://learn.microsoft.com/en-us/dax/if-eager-function-dax -cdot above Examples part.
upvoted 3 times
...
Tex02
2 months, 1 week ago
interestingly this article - https://dax.guide/if-eager/ - indicates that if and if.eager do pretty much the same thing but if.eager optimises better. So I can't say the answer is incorrect but which one are they looking for can't say.
upvoted 1 times
...
b9e3c84
2 months, 2 weeks ago
The correct answer is IF, HIGH and MEDIUM
upvoted 3 times
...
nelrosell
2 months, 2 weeks ago
IF is also fine
upvoted 2 times
...
Endeetheanalyst
2 months, 2 weeks ago
Answer is correct. https://learn.microsoft.com/en-us/dax/if-eager-function-dax
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel