Calculate the difference between two times

[Anonymous]

Hi,

I am trying to calculate the difference between two times ("Sluttid" means "End time" ), and ("Sidste opg. **bleep**" means "Last task done"). 

"Sluttid" is a column placed in one table called "SD", where "Sidste opg. **bleep**" is a column measure in another table called "Data":

Sidste opg. **bleep** = CALCULATE(MAX(Data[Udført tid]);   ALLEXCEPT(Data;Data[Udfører];   Data[Ønsket dato]))

The result I want is that in the first row I will get: 16:00:00-15:59:26 = 34 sek. The next row: 1 minut and 2 sek. And so on....

I have tried datediff and many other things, but nothing seems to work..

Can anybody help? 🙂

- Nina

[amitchandak · Accepted solution]

@Anonymous , not very clear with description

it can be

Sidste opg. **bleep** = CALCULATE(datediff(Min(Data[Udført tid]), MAX(Data[Udført tid]), hour); ALLEXCEPT(Data;Data[Udfører]; Data[Ønsket dato]))

Can you share sample data and sample output in table format?

[Anonymous]

Hi,

Thank you for the help. It helped me out. 

The formular I needed was: 

Measure = CALCULATE(DATEDIFF(MIN('Data (raw)'[Sidste opg. **bleep**]);MAX(SD[Sluttid]);MINUTE))

I just do not understand why "min" and "max" is needed here. But it do not work without.

-Nina

[Pragati11]

Hi @Anonymous ,

Not sure if you looked at few existing threads in the community for same issue:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Time-Calculation/m-p/1145199

https://community.powerbi.com/t5/Desktop/HIGHLY-URGENT-Calculate-Time-Stamp-Difference/m-p/1210618

Thanks,

Pragati