Forum Discussion
Solved
Contact Tracing
Hi! We're trying to put together a rudimentary contact tracing visual based on some data extracts. The data source is very simple: Date;Cargiver Name;Patient Name Using this I can get the...
Yes! Exactly this! I will dig in to it. Thank you!
Greg_Deckler
Community Champion
Community ChampionIt sounds to me like a Transitive Closure issue. See this link: https://community.powerbi.com/t5/Quick-Measures-Gallery/Transitive-Closure/td-p/783828
Ok, so I got excited and jumped the gun a bit. This is almost what I need. Only in the Input Table, I need the relationship to be bidirectional instead of just from left to right.
So using the example in the link, the output for 1 would be:
1->2;3;4;5;6;7;8
based on all contact of the numbers involved.
I need to find every contact that 1 had, either directly or indirectly.