Forum Discussion
Call a column from another table in Custom add Column
Hi All
I have two tables for example tableA and table B.
I would like to add a custom column in tableA which need to call one of columns in tableB for the calculation.
Like, [Qty] from tableA needs to be multiply by [Unit_Cost] from table B to create [Total_Cost] in tableA.
Any help would be highly appreciated.
5 Replies
Hi Matt_Gol
Thank you so much for reaching out to our Power BI community! Our awesome community have kindly helped another community member with this question. I beleive this post may help you.
Solved: Add new calculated column with values from 2 table... - Microsoft Power BI Community
Best,
Kelly Kaye
Thanks so much Anonymous , but I have problem with this solution, it doesn't seem to work on DirectQuery. It asked me to switch all the tables to import mode. Is there any other solution that I can apply on the Direct Query mode?
Any idea please?
Hi Matt_Gol ,
If the tables are connected in Power BI using DirectQuery mode, creation of calculated columns is restricted. This is one of the limitations of DirectQuery mode in Power BI.
Rather than creating a caluclated column you will have to create a measure using DAX expression.
If it still does not help, please provide your pbix file without privacy information and your desired output.
Best regards.
