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.
Could you please clarify more details about "group nodes", "edges" and "families"? If possible, please share some dummy data and expected result.
Regards,
Jimmy Tao
Hi Jimmy,
I'm working with family trees.
Here's how I'm using the terms:
Here's an example with two families.
This is a sample edge table. The "source" is the "parent" and the "target" is the "child".
Source | Target |
A | E |
A | F |
B | E |
B | F |
C | E |
C | F |
D | E |
D | F |
E | G |
F | H |
I | J |
J | L |
K | L |
L | M |
M | N |
N | O |
N | P |
The first family includes: A, B, C, D, E, F, G, H
The second family includes: I, J, K, L, M, N, O
I have a working M Query that produces results but is slow (upwards of 10 minutes for 7 families of 80 total nodes). I'm more than happy to upload it but I'm hoping that there is a simple way Power BI can separate the nodes by families.
Thanks
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |