Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |