custom link

Hi Power Bi Developer

First i would like to say awesome product !

Can you please assist with the following issue .

I have multipale tables that i need to link but they do not recognize each other .

1) History Lines

1.1) Item Code  A

2) History Line

2.1)  Item Code A B

3) Multistor Trn

3.1) Item Code B

3.2) Inventory Group C

4) Inventory Groups

4.1) Inventory Group C

The History lines have my sales transactions but it is not linked to a ledger account tables . So i would like to pivot my QTY coulum sold in my history lines linked to my ledger account . So that in the end i know by ledger account what is the total QTY sold .