Forum Discussion
Helper ISummerize data from 3 different tables
Hi all,
I'm new to powerBI and DAX... and need some help with taking the sum of data from different columns from different tables.
Below you can see a picture what I want (calculated the first 2 lines... sorry for my drawing skills).
So the data is grouped on Name and calculates the amount of products that are ordered during a period (filter). We also have the quantity of products available at our distribution centre (BME.Quantity) and a Safety Stock (SS.Quantity). Now i want to summerize the 3 columns. By example the first line (ACN Cream) should be 5568, second line 2266, ...). Below you can also find our DTB Structure (Salesforce combined with some self made tables and our distributres warehouse export). Please help me out :)
THANKS!!!
Dennis
7 Replies
v-danhe-msftMicrosoft Employee
Hi dennisdepoorter,
Could you please share some sample file or the pbix file to have a test if possible?
Regards,
Daniel He
- Ashish_Mathur
Super User
Hi,
If the last 3 columns are measures the, write this measure
=[Quantity]+[BME.Quantity]+[SS.Quantity]
- dennisdepoorter
Ashish_MathurDon't work (he mentioning "can't find the columns"... this is because it's in 3 different tables I think?
v-danhe-msftSorry, can't do... is connected with Salesforce and all our data.... if you need some specifiek information about table relations,... don't hesitate to ask! :)
- dennisdepoorter
I made a copy of the DTB with fictional data:
https://www.dropbox.com/s/vupkg4chx07v5hf/test.pbix?dl=0
Hope this helps to figure out the problem :smileyembarrassed: