Forum Discussion

Foolke's avatar
Foolke
Helper I
6 years ago
Solved

Calculate time between 2 dates

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)?

Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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

     

3 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    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's avatar
      Foolke
      Helper I
      6 years ago

      Data sample

      TicketNrResolution_Actual_DateTimeBetweenSolved_Date
      INC-44599629/01/2020 9:43 29/01/2020 9:43
      INC-44748731/01/2020 15:23 31/01/2020 15:23
      INC-45578729/01/2020 9:15 29/01/2020 9:15
      INC-4626116/02/2020 21:30 6/02/2020 21:30
      INC-46632631/01/2020 11:58 31/01/2020 11:58
      INC-46662331/01/2020 13:03 31/01/2020 13:03
      INC-4720847/02/2020 12:40 7/02/2020 12:40
      • Mariusz's avatar
        Mariusz
        Community Champion
        6 years ago

        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