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.
* Answer: B. No * Explanation: - In Power BI, a fact table (like Sales) can have multiple date foreign keys (e.g., Order Date, Due Date, Delivery Date). - A Date table can only have one active relationship with the Sales table at a time. The others must remain inactive. - To analyze sales by different dates, you typically: -- Create inactive relationships between the Date table and the other date keys. -- Use the USERELATIONSHIP function inside CALCULATE to temporarily activate the relevant relationship for a measure.
OrdersByDueDate = CALCULATE( [Total Sales], USERELATIONSHIP('Sales'[Due Date], 'Date'[Date]) ) The USERELATIONSHIP() function in DAX is designed specifically for this situation — where you have multiple date columns (foreign keys) in one fact table (Sales), but can only have one active relationship with your Date dimension at a time. 📊 Scenario Recap: You have: A Date table A Sales table with: Order Date Due Date Delivery Date You want to analyze sales over time using each of those dates independently — for example: Orders by Order Date Sales due by Due Date Shipments by Delivery Date
The question is whether it can be used in an active relationship, the answer is B!