Forum Discussion

TaroGulati's avatar
TaroGulati
Icon for Helper III rankHelper III
1 year ago

Time difference two tables

Hi all,    I am having difficulty in calculating the time difference between two tables.    I need to calculate sum of time difference from table 2 between type A and B which is 21 min. Thi...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
1 year ago

TaroGulati 

How did you get the date difference column? did you use DAX to calcuate? 

TaroGulati's avatar
TaroGulati
Icon for Helper III rankHelper III
1 year ago

Hi, that i calculated using the min date for A and min date B for each combination and then summed up. 

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    1 year ago

    TaroGulati 

    pls see if this is what you want

     

    • TaroGulati's avatar
      TaroGulati
      Icon for Helper III rankHelper III
      1 year ago

      Hi, thanks for the feedback. in this case result should be 11 not 10. Agree?

      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        1 year ago

        TaroGulati 

        totally 21 mins, then substract 6 mins from row 2 and 5 mins from row 3.

        21-6-5=10. 

        if I misunderstood the calculation logic, pls correct me.