Forum Discussion
Create a Calculated Column from Different Tables
I am using DirectQuery storage mode. I have a table where I want to create a new column using two columns already present in my table. However, those two columns come from different tables. Using DI...
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
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