calculate hours BETWEEN TWO DATES

[adnankabina]

i have plan date coulmn 

PLANNED_PKUP_DTT                      ACTUAL_PKUP_DTT                          DIFFACT_PLANNED

10/12/2021 12:22:00 PM                10/13/2021 12:00:00 AM                    288

10/12/2021  4:16:00 PM                  10/12/2021 9:09:44 AM                      336

DIFFERENCE BETWEEN BOTH IN HOURS 

I USED THIS 

DIFFACT_PLANNED = DATEDIFF(IBdata[PLANNED_PKUP_DTT], IBdata[ACTUAL_PKUP_DTT], HOUR)*24

is it minutes ?

[PhilipTreacy · Accepted solution]

hi @adnankabina 

Try this

Measure = ABS(DATEDIFF(SELECTEDVALUE('IBdata'[ACTUAL_PKUP_DTT]), SELECTEDVALUE('IBdata'[PLANNED_PKUP_DTT]), HOUR)) 

The ABS() function just returns the absolute value of the number, regardless of whether it's positive or negative.  You may have cases where Actual - Planner (or Planned - Actual) results in a negative number of hours.

Regards

Phil