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. •...

Questions › Category: PL-300 › 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. •…

0 Vote Up Vote Down

Admin Staff asked 4 months ago

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: 
    



This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.