Looking for a way to trace transactions from a single table/journal

[ChrispyMan]

I have a table with 4-5M records. My task is to identify all of the transactions from the orgin. 

Get all the "To" from A
The get all fo the "To" from the result
Next level, next level, etc.. until I have all of the data

Date	ID	From	To	USD
1-Jan	1	A	C	$  700.00
2-Jan	2	A	B	$  200.00
2-Jan	3	B	C	$  900.00
5-Jan	4	C	D	$  600.00
6-Jan	5	A	D	$  500.00
7-Jan	6	B	C	$  400.00
7-Jan	7	C	A	$  300.00
10-Jan	8	D	C	$  800.00
11-Jan	9	B	A	$  100.00
11-Jan	10	E	C	$  400.00

The result for person A might be

A sent to C, B, D
C sent to D, A

B sent to C
D sent to C

I attempted this a number of times using Power Query in different ways and I am stumped. Its not a static data set. I went the route of merging and could do a couple of levels before getting jammed up. Wondering if someone has done something like this before and could point me in the right direction.

Thanks!

[Ashish_Mathur]

Hi,

Your expected result is just not clear.  In the expected result section, you say the "result for person A" - why then have you shown B to C and D to C?????.  In this question what is the use of the Date, ID and USD columns?  Do you want to see he result in a Table visual?

[ChrispyMan]

Thanks for replying. I am trying to trace from an origin person through the data set to fina all down stream records even if the orginal person is not part of the transactions.

For a i need to finad all related transactions which orginated for the frist. Hope this helps.

[freginier]

You can use PATH function in DAX or use a network visual 

https://simplebiinsights.com/power-bi-path-function-for-parent-child-hierarchies-in-dax/

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&exp=ubp8

______________________________________________________

If you found this post helpful, please give Kudos C