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
bcap01Helper II
Helper IIthe error message i am getting is, "A single value for column '' in table '' caanot be determined. This can happen when a measure formula refers to a column that contains values without specifiying an aggregation..."