Get startedGet started for free

Active and inactive relationships

Sales connects to Date through both OrderDate and DeliveryDate, but only one relationship can be active. The sales team needs Revenue counted by order month, and logistics needs Deliveries counted by delivery month.

The app shows the model and the month each measure counts each order in. Try each combination of the active relationship (step 1) and the USERELATIONSHIP switch (step 2). Which setup lets the sales team see revenue by order month and logistics see deliveries by delivery month?

This exercise is part of the course

Data Ingestion and Semantic Models with Microsoft Fabric

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise