Forum Discussion

ringocheng618's avatar
ringocheng618
Frequent Visitor
5 years ago

Create Decomposition Tree by Cleaning Bitcoin Transactions

Hello,

 

Currently working on a school project to investigate on the Dread Pirate Silk Road case. My goal is to create a decomposition tree to show possible relationship between Dread Pirate's bitcoin wallet and other wallets. 

 

So I have the following data that show Dread Pirate Wallet A (1HQ3Go3ggs8pFnXuHVHRytPCq5fGG8Hbhx) transactions: whether he is sending payment and receiving payment. 

 

So if I get details for Wallet B (bc1qa5wkgaew2dkv56kfvj49j0av5nml45x9ek9hz6) the last row of the excel sheet, it will show the bitcoin inflow and outflow for wallet B. If I want to create a decomposition tree that show possible relationship between wallet A, wallet B and some other wallets that wallet A sent payment to, how can I use Power Query to create this relationship? I am not too sure how I can build a relationship table based on a common field. Should I append them? Thanks.

Need Help
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    ringocheng618 

     

    Not very clear with your requirement. And there is no relationship management feature in Power Query in Power BI.

     

    Can you share a sample in a table format that I can copy paste data to test, and show us your expected output based on that table. BTW, there is no relationship management feature in Power Query in Power BI.


    Paul Zheng _ Community Support Team