Help to get a measure that uses two tables

[Anonymous]

Hello all,

I'm trying to replace an excel calculation for a power bi dax expression. This calculations are related to car travels. at the excel i have the following columns in order to get to the total unit cost:

Same day	Qtt Hours	Util. <  1day
0	0	0
0	0	0
1	0.125	6.24
IF(CheckOutDate=Check InDate,1,0)	IF(SameDay=1,CheckOutDate-CheckInDate,0)	IF(Qtt Hours>0.1666666667,Vehicles['DailyValue'],Vehicles['HalfDailyValue'])

I've tried to create this on my power bi file, the same day column and the qtt hours was easy, I've created a new column on my main table. But now I'm struggling to get the third columns.

I'm trying the following sentence but getting this error:

Thanks in advance,

Miguel 

[PhilipTreacy]

Hi @Anonymous 

What code are you using to create the column CarpoolBackup1[QtdHoras] ?

The error is saying that to create CarpoolBackup1[utilMaiordia] you need the value from CarpoolBackup1[QtdHoras] but the value in CarpoolBackup1[QtdHoras] relies on the value in CarpoolBackup1[utilMaiordia]

Regards

Phil