cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CGlembocki Frequent Visitor
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
Community Support Team
Community Support Team

Re: Grouping by families

@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

CGlembocki Frequent Visitor
Frequent Visitor

Re: Grouping by families

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
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,202)