Exam PL-300 topic 2 question 57 discussion

HOTSPOT
-

You have a Power BI data model that contains a table named Stores. The table has the following columns:

• Store Name
• Open Date
• Status
• State
• City

You need to create a calculated column named Active Store Name that meets the following requirements:

• When the value of the Status column is “A”, the value in the Store Name column must be returned.
• When the value of the Status column is NOT “A”, the value in the Store Name column that is prefixed with "Inactive - " must be returned.

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

NOTE: Each correct selection is worth one point.

Suggested Answer: