Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
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.
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
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.
How can we know the price of the item from the price list? It seems to be joined with the supplier
@amitchandak Thanks for your reply.
Price of the item is in the Retailer column Pricelist[Retailer]
Joins are all with StcokCode
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |