If the relationship for the Invoice Date Key from the Sale table is inactive, how should you create a line chart for Quantity by the invoice date?

If the relationship for the Invoice Date Key from the Sale table is inactive, how should you create a line chart for Quantity by the invoice date?

• A. Delete the relationship based on the delivery date.
• B. Create a measure using USERELATIONSHIP.
• C. Activate the relationship based on the invoice date.
• D. Use the TREATAS function to manage relationships.

Answer: (B)

To create a line chart for Quantity by the invoice date when the relationship for the Invoice Date Key from the Sale table is inactive, the most effective method is to create a measure using the USERELATIONSHIP function. This function allows you to specify an inactive relationship to use in your calculations without permanently altering the model's relationships. By constructing a measure that utilizes USERELATIONSHIP, you can selectively activate the relationship for the purpose of your visualizations, allowing Power BI to interpret and aggregate the data correctly according to the invoice date. This is particularly useful in scenarios where multiple date dimensions exist, and an inactive relationship is necessary for other calculations or analyses. Other options either do not address the need for temporarily activating the inactive relationship (such as deleting another relationship or activating it directly) or involve different approaches that may not directly resolve the specific need for creating the line chart based on the invoice date. Using USERELATIONSHIP is a targeted solution that precisely meets the requirements of this scenario.

To create a line chart for Quantity by the invoice date when the relationship for the Invoice Date Key from the Sale table is inactive, the most effective method is to create a measure using the USERELATIONSHIP function. This function allows you to specify an inactive relationship to use in your calculations without permanently altering the model's relationships.

By constructing a measure that utilizes USERELATIONSHIP, you can selectively activate the relationship for the purpose of your visualizations, allowing Power BI to interpret and aggregate the data correctly according to the invoice date. This is particularly useful in scenarios where multiple date dimensions exist, and an inactive relationship is necessary for other calculations or analyses.

Other options either do not address the need for temporarily activating the inactive relationship (such as deleting another relationship or activating it directly) or involve different approaches that may not directly resolve the specific need for creating the line chart based on the invoice date. Using USERELATIONSHIP is a targeted solution that precisely meets the requirements of this scenario.