Forum Discussion

Bharani's avatar
Bharani
Regular Visitor
7 years ago

Find time duration between 2 dates (Datetime format)

Hi Experts - Am new to Power BI.. Hope u can crack my query in a min...   I need to calculate "Number of minutes" between 2 dates which is in Datetime format..Below date is an example..   3/11/20...
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Bharani,

 

You could try with the dax formula below to create the calculate column.

 

diff =
VAR tem = 'CountMinutes'[accepttime] - 'CountMinutes'[logtime]
RETURN
    HOUR ( tem ) * 60
        + MINUTE ( tem )

Then you will  get the output below.

 

 

Best Regards,

Cherry

Bharani's avatar
Bharani
Regular Visitor
7 years ago

Thanks!! Does it work if logtime and accepttime are on different days, months or years?