Forum Discussion
Issue when importing from an Access Database - Calculated Fields / Columns
Hi TiagoKorynek,
Based on test, calculated field works and I haven't faced your issue, below is the test file.
>>>>TblTcDelIDDATESTNATAATA4DIGITATA2DIGITATALAST2ATASecondaryDELAY HRSDELAY MINSAOGDelayTotalMinsEvent TypeSeverity Index
In addition, can you fix your column name? It is hard to understanding above text.
Regard,
Xiaoxin Sheng
Hi TiagoKorynek,
Based on test, I can import the calculate fields to power bi,these fields display the correct value.
Can you provide detail contents or share some sample file to test?
Regards,
Xiaoxin Sheng
How do I upload a database or table?
Hi TiagoKorynek,
>>How do I upload a database or table?
You can share the sample data of table and the formula of calculated field.
Regards,
Xiaoxin Sheng
Oh that's a shame that we can't do a straight file swap.
TblTcDelIDDATESTNATAATA4DIGITATA2DIGITATALAST2ATASecondaryDELAY HRSDELAY MINSAOGDelayTotalMinsEvent TypeSeverity Index
1 15/01/2001 MAN 52-00 DOORS 52-00 52 0 2 03 No 123 DLY 0.55 2 24/01/2001 MAN 77-00 ENGINE INDICATING SYSTEM 77-00 77 0 2 39 No 159 DLY 0.55 3 30/09/2001 PMI 36-00 PNEUMATIC SYSTEM 36-00 36 0 1 02 No 62 DLY 0.3 4 01/01/2006 AMS 52-00 DOORS 52-00 52 0 0 33 No 33 DLY 0.24 5 01/01/2006 GVA 21-31 PRESSURIZATION CONTROL SYSTEM 21-31 21 31 6 40 No 400 DIV 1.6 6 02/01/2006 PRG 34-00 NAVIGATION 34-00 34 0 0 29 No 29 DLY 0.22 The column I am having an issue with has the following formula
((IIf([Event Type]="ATB",0.75,(IIf([Event Type]="CANX",0.6,(IIf([Event Type]="DIV",0.8,(IIf([Event Type]="DLY",0.1,(IIf([Event Type]="IFSD",0.9,(IIf([Event Type]="RTOHS",0.5,(IIf([Event Type]="RTOLS",0.4,(IIf([Event Type]="RTS",0.3,0)))))))))))))))))+(IIf([DelayTotalMins]<30,0.12,(IIf([DelayTotalMins]<60,0.14,(IIf([DelayTotalMins]<120,0.2,(IIf([DelayTotalMins]<120,0.3,(IIf([DelayTotalMins]<180,0.45,(IIf([DelayTotalMins]>179.9,0.8,0))))))))))))+(IIf([AOG]="-1",1,0))
Thanks
