Calculated Column Using 2 Different Tables

[DHutchinson]

Hi all,

I am currently working on a BI report and could use some input. In one table I have summarized data (#'s) and in another column I have revenue ($'s). What I would like to do is have one column from Table A / column from Table B to produce a value per unit.

Any insight would be greatly appreciated! Thank you all

David

[amitchandak]

@DHutchinson , if these tables have master-> Fact(details) relation you can create 1-M join and get data together,

else you should create a common dimension to analyze

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...