Create a Calculated Column from related Tables

[Anonymous]

Hi Guys, 

I am trying to create a visual which shows the following:

Revenue  

Cost Time 

Expense 

Gross Profit 

Gross Margin

Each of these fields are present in the Revenue, Cost Time, Expense tables respectively. Gross profit and Margin have to be calculated.

Now the first challenge is to render  ' Revenue ' , Cost- time  and Expense because these fileds should be subtracted from the 'Vendors/ Billables' field which is present in the Revenue table. 

All these tables are joined by a lookup Table but it is not letting me add a new calculation. Please helpTable RelationshipsOutput 

[v-yuezhe-msft]

@Anonymous,

Could you please share sample data of these tables and post expected result here?

Regards,
Lydia