Calculate time between 2 dates

[Foolke]

All, all, all, all,
I have several date/time columns. Start_date, Mid_date, End date. In power query I want to calculate how much time there is between e.g. Start_date& Mid_date, Mid_date & end_date.
I thought the best way to do this was to use several extra columns in Power Query.
How do I do that?
Or do I do this better through a measure in PowerBi (DAX)?

[Mariusz]

Hi @Foolke 

Can you create a data sample?

Yes, the easiest way would be to add extra columns in PQ.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Foolke]

Data sample

TicketNr	Resolution_Actual_Date	TimeBetween	Solved_Date
INC-445996	29/01/2020 9:43		29/01/2020 9:43
INC-447487	31/01/2020 15:23		31/01/2020 15:23
INC-455787	29/01/2020 9:15		29/01/2020 9:15
INC-462611	6/02/2020 21:30		6/02/2020 21:30
INC-466326	31/01/2020 11:58		31/01/2020 11:58
INC-466623	31/01/2020 13:03		31/01/2020 13:03
INC-472084	7/02/2020 12:40		7/02/2020 12:40

[Mariusz · Accepted solution]

Hi @Foolke 

You can add a column like below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn