Microsoft Exam PL-300 Topic 2 Question 61 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 61
Topic #: 2

[All PL-300 Questions]

What should you do to address the existing environment data concerns?

Aa calculated column that uses the following formula: ABS(Sales[sales_amount])

Ba measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

Ca measure that uses the following formula: SUM(Sales[sales_amount])

Da calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

Show Suggested Answer

Suggested Answer: B

by Oliva at Jan 12, 2025, 05:20 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

1 days ago

The question is a real brain-teaser, but I have to say, option D is the way to go. It's the most comprehensive solution.

upvoted 0 times

...

16 days ago

D is the winner! Gotta love that IF(ISBLANK()) function. It's like a magic wand for dealing with those pesky blank cells.

upvoted 0 times

...

23 days ago

The question is a bit tricky, but I think D is the best solution. It's important to have a robust formula that can handle any data issues.

upvoted 0 times

5 days ago

I agree, D seems like the most reliable option.

upvoted 0 times

...

26 days ago

I agree with Vanna. Option D is the way to go. Handling blank values is crucial in this scenario.

upvoted 0 times

...

1 months ago

I think we should use option A) a calculated column with ABS function.

upvoted 0 times

...