Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, community! I have a query where I need to add a custom column to match what my excel spreadsheet does, the formula is:
IF(MOD(24*MOD(TEXT([#"Land Time (Military Time)"],"00\:00")-TEXT([#"Take Off Time (Military Time)"],"00\:00"),1),1)<0.6,24*MOD(TEXT([#"Land Time (Military Time)"],"00\:00")-TEXT([#"Take Off Time (Military Time)"],"00\:00"),1),((1440*MOD(TEXT([#"Land Time (Military Time)"],"00\:00")-TEXT([#"Take Off Time (Military Time)"],"00\:00"),1))-1)/60))
Is this easy to convert to a Power Query expression?
Solved! Go to Solution.
@rhaddad87 , With help from Duration
Duration.Days([Military Time])*24 + Duration.Hours([Military Time])+ Duration.Minutes([Military Time])/60.0 + Duration.Minutes([Military Time])/3600.0
Change formula as per need
@rhaddad87 , With help from Duration
Duration.Days([Military Time])*24 + Duration.Hours([Military Time])+ Duration.Minutes([Military Time])/60.0 + Duration.Minutes([Military Time])/3600.0
Change formula as per need
Thank you so much, Amit! You are truly a rockstar in this community @amitchandak
User | Count |
---|---|
54 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |