Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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
Proud to be a Super User!
User | Count |
---|---|
81 | |
76 | |
70 | |
69 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |