Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ChrispyMan
Frequent Visitor

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

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

 

DateIDFromToUSD
1-Jan1AC $  700.00
2-Jan2AB $  200.00
2-Jan3BC $  900.00
5-Jan4CD $  600.00
6-Jan5AD $  500.00
7-Jan6BC $  400.00
7-Jan7CA $  300.00
10-Jan8DC $  800.00
11-Jan9BA $  100.00
11-Jan10EC $  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!

 

3 REPLIES 3
Ashish_Mathur
Super User
Super User

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?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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
Solution Specialist
Solution Specialist

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.