Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |