Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a lab fixes data. Each customer order comes to lab for a check and fix if needed.
The open date is the date the customer opens a ticket.
The received date is when we receive the unit in our lab.
The closed date is when the ticket is closed by us.
I want to make a BI relationship so the managers will be able to view amount of units by open\received\closed dates and view status of units in lab by date.
Here is the data relationship I did:
The 2 dot relationships are not active.
Whe I try ti activate them I get an error:
"You cant create a direct relationship between Closed_Dates and Main that would introduce abiguility between table Date and Closed_Dates. To make this relationship active, deactivate or delete one of the relationships between Date and Clsoed_Dates first."
I read that Power BI relationship directions matter, I tried to do many:many with a direction but with no luck.
Any help with this on plea
Hi @yanivshe
You are already have relations between Main and Data tables via Open_Dates, so it's incorrect to try create any other ways
Maybe you should try to create the onlye table with Datas (your 3 tables have similar structure now)
Use columns :
ID
DataType (Open/Receive/Close)
Date
Datetime
And further just use filters by DataType
It should be enough for a lot of scenarios
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |