Sales less free multiple with cost

[brinky]

Good morning,

Could someone assist me to get this measure.
I have 3 tables Pricelist, Stocksuppliers & CustomerTransactions

I would like to get the following:
CustomerTransactions[Qty]-CustomerTransactions[FreeQTY] then multiply with Pricelist[Retailer]

[Greg_Deckler]

Sample data posted as text would be tremendously valuable. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

Not really enough information to go on as we do not know what columns the tables are joined on. But, you might check out LOOKUPVALUE.

[brinky]

@Greg_Deckler 

Thanks for your comment unfortunatly cannot share data.

As for columns and joins I have posted a screenshot of the tables and also stated how they are joined. All joins are with StcokCode.

Regards,

Stephen

[Greg_Deckler]

OK, but can you make up sample data that emulates the issue? You generally only need a few rows of fake data. I will take a look at the relationships and see what I can figure out but it is infinitely harder.

[amitchandak]

How can we know the price of the item from the price list? It seems to be joined with the supplier

[brinky]

@amitchandak  Thanks for your reply.

Price of the item is in the Retailer column Pricelist[Retailer]

Joins are all with StcokCode