topic Re: calculate Turn-around-time based on two column values in DAX Commands and Tips

calculate Turn-around-time based on two column values

SBC — Fri, 16 Sep 2022 07:02:50 GMT

How to calculate the duration of date and time in one column in power bi.

example:

base on indate and outdate column, duration column need to be calculated.

Thanks,

SBC

Re: calculate Turn-around-time based on two column values

Anonymous — Fri, 16 Sep 2022 07:22:04 GMT

You can easily do this in Power Query, which is the most suitable for this kind of task. Create a custom columns and insert the following formula:

Duration.TotalMinutes([InDat]-[outDate])

EDIT: You can then use this other formula to obtain the hours format:

=Number.From([Duration_Column])*24

Since you asked for this in DAX, I feel like I should also point out how to help you with DAX. Power Query remains the best tool, but in case here is what you can use with DAX:

DATEDIFF ( Table[inDat], Table[outDate], SECOND )

This will give you the duration in seconds, you can pick other parameters as you prefer, of course.

Re: calculate Turn-around-time based on two column values

tamerj1 — Fri, 16 Sep 2022 11:31:26 GMT

Hi SBC
Please refer to attached sample file with the solution

Duration = VAR Period = DATEDIFF ( 'Table'[InDate], 'Table'[OutDate], SECOND ) VAR Days = QUOTIENT ( Period, 86400 ) VAR Hours = QUOTIENT ( Period, 3600 ) - Days * 24 VAR Minutes = QUOTIENT ( Period, 60 ) - Days * 1440 - Hours * 60 VAR Seconds = Period - Days * 86400 - Hours * 3600 - Minutes * 60 RETURN Days & " days : " & Hours & " hrs : " & Minutes & " mins : " & Seconds & " secs"