Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
CGlembocki
Frequent Visitor

Grouping by families

I'm trying to group nodes by edges into separate families. I have an edge table of 100+ edges relating to 30+ nodes. How does one group families? Also, each family can have 2 or more top nodes.
2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@CGlembocki ,

 

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:

  • "Nodes" - separate objects that exist in a dataset (namely, directed relationships between people)
  • "Edges" - the links between people
  • "Groups" - the individual families

Here's an example with two families. 

This is a sample edge table. The "source" is the "parent" and the "target" is the "child".

 

SourceTarget
AE
AF
BE
BF
CE
CF
DE
DF
EG
FH
IJ
JL
KL
LM
MN
NO
NP

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.