Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Power BI allows only one active relationship between a fact table (like Sales) and a dimension table (like Date). By default, only one of the date fields (e.g., Order Date) can have an active relationship with the Date table. To analyze sales over time using the other date fields (Due Date, Delivery Date), you can create inactive relationships and then use the USERELATIONSHIP() function in your DAX measures to activate them temporarily.
you need to link the tables using the three Date fields require in the analysis. Only one relationship between two tables can be active. In the measures involving the Dates fields linked with the inactive relationships, the RELATIONSHIP() function is required to turn (within that measure) that relation to Active
The correct answer is A. you use USERELATIONSHIP