Valid PL-300 Dumps shared by ExamDiscuss.com for Helping Passing PL-300 Exam! ExamDiscuss.com now offer the newest PL-300 exam dumps, the ExamDiscuss.com PL-300 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com PL-300 dumps with Test Engine here:
You have a Power BI data model that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys. *Due Date *Order Date *Delivery Date You need to support the analysis of sales over time based on all three dates at the same time. Solution: From the Data pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Deliver Date as calculated tables. You create active relationships between the sales table and each date table. Does this meet the goal?
Correct Answer: B
Renaming the date table and creating calculated tables for "Order Date" and "Delivery Date" with DAX expressions would not fully meet the goal. Power BI only allows one active relationship between two tables at a time. Therefore, you cannot have active relationships between the sales table and all three date tables simultaneously. Instead, you would typically create one active relationship (e.g., with "Order Date") and use DAX functions like USERELATIONSHIP to switch between different relationships when needed for analysis. Alternatively, you could use a single date table and create multiple relationships, using inactive relationships and the USERELATIONSHIP function to activate them in specific measures.