Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Has anyone attempted to model pedigree/lineage data?
I have an existing model which contains a population table of all of the ID's (~50,000 rows)
e.g ID = 1, SEX = M, FID = 123, MID = 321
I've played around with generating heirarchies but it gets tricky with multiple parents (@ImkeF )
Looking for an output similar to the below and to create performance based metrics using these parent/child relationships.
Happy to provide more detailed information if required but wanted to see if anyone here has attempted this type of analysis?
Hi @Farmah ,
Could you pls provide some sample data from your oringinal table?
Remember to remove the confidential information.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 103 | |
| 66 | |
| 65 | |
| 56 |