Forum Discussion
Create a Calculated Column from Different Tables
mwimberger Thanks! I'm not actually creating a new table but I think creating a unique key in my query for each table and creating those relationships beforehand helped me merge the queries into one table so I could access the columns I wanted.
I found this article really helpful: https://community.powerbi.com/t5/Desktop/merge-queries/td-p/463371
Hi Anonymous
You could try the RELATED function in your table - which will require a relationship between the two tables. DirectQuery will be the stumbling block here I suspect. DirectQuery may not be able to allow you to add columns .
Or if you need a result from the two columns instead consider using two measures
[Measure1] = sum(table1[Col1])
[Measure2] =sum(table2[Col2])
[Measure3] = divide([Measure1],[Measure2])
Not sure if that helps any?
Phil Seamark posted a solution here that may help by creating a new table :
Hope that helps
Cheers
Manfred
mwimberger Thanks! I'm not actually creating a new table but I think creating a unique key in my query for each table and creating those relationships beforehand helped me merge the queries into one table so I could access the columns I wanted.
I found this article really helpful: https://community.powerbi.com/t5/Desktop/merge-queries/td-p/463371
Awesome, glad you had a win!
Cheers
Manfred
I know it has been some time, but how did Merge solve the problem for you? You can't merge in Direct Query. I can only think you converted to Import Mode... something I cannot do in the project I am working on.
