Forum Discussion
How to divide data from two colums coming from different data sources
Hi,
Refer the below file with boxes per hour column.
https://www.dropbox.com/s/0qg1x6n67vmmj3x/August%20Harvest.pbix?dl=0
I think you should soend some time to learn DAX, so some of the usefull youtuube channels where you can learn it.
https://www.youtube.com/channel/UCy2rBgj4M1tzK-urTZ28zcA
Impactful IndividualHi
You need to use RELATEDTABLE function to call columns from other related table.
https://msdn.microsoft.com/en-us/library/ee634226.aspx
= SUMX( RELATEDTABLE('InternetSales_USD')
, [SalesAmount_USD]) 
Thank you for your reply. I tried the related table formula and i could not get it to work. After some research, I tried to use the New Measure feature instead of New Colum. Using this feature, I was able to reference both tables in the formula but I still get an error message. I first tried it without the SUM function and got an error. The training video i was watching recommended using the sum function but it unfortunately is not working for me.
Any other recommendations?
- dilumd
Hi
Without looking at your data model it's difficult to give you a proper solution, (if possible share with me some dummy data of your two tables) however I tried to imitate your scenario and my PBIX file is attached.
kindly check my steps and check whether you’re getting the result you want.
https://www.dropbox.com/s/mtmtgzd0xcfluq4/maximus1.pbix?dl=0
dilumd,
Thank you for your help. I tried to replicate your formula but I still get an error message.
Under my August Production, I tried to replicate your formula as a new measure and as a new column and get an error on both.
I have attached my data below. Thank you for taking the time, i really appreciate all the help.
https://www.dropbox.com/s/m9vv6zbxjjtebu9/August%20Harvest.pbix?dl=0
v-ljerr-msftMicrosoft Employee