cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors