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.
I am trying to create a call log report in which I have two tables. One for the extensions and another with the actual call logs. I would like to create a visual which shows all calls for an extension whether they originated or were placed to the extension but when I try to create the relationship it only allows one active. In the image below I created a relationship between the extension on the left and the ToNumber and FromNumber columns on the right. Any idea how I can accomplish this so I can show all calls either incoming or outgoing for a single extension? Thanks!
You could try creating the relationships you need through merging your tables in the Query Editor
You could unpivot the calls table so there is a seperate row for incoming and outgoing details and a single column for number. You would have to be carefull not to double count the calls then though.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |