Forum Discussion
bcap01
Helper II
Helper IISimple JOIN
Hello, I am a PowerBI/DAX newbie. I am looking to understand how to JOIN two tables to do a simple calculation. For example, lets say I have two tables Invoices and Costs that JOIN based on ...
HI bcap01,
You cannot directly use different table columns in one formula, you can try to reference or use current table value to lookup corresponds table values and use this in calculations.
Using RELATED and RELATEDTABLE in DAX - SQLBI
Power BI Compares Two Columns in Different Tables - SPGuides
Regards,
Xiaoxin Sheng
HI bcap01,
You cannot directly use different table columns in one formula, you can try to reference or use current table value to lookup corresponds table values and use this in calculations.
Using RELATED and RELATEDTABLE in DAX - SQLBI
Power BI Compares Two Columns in Different Tables - SPGuides
Regards,
Xiaoxin Sheng