Forum Discussion

Giavo's avatar
Giavo
Icon for Helper III rankHelper III
8 years ago
Solved

DATEDIFF between Rows and GROUP BY

Hello everybody. 2 DAX Questions about DATEDIFF. 1)I need to find the difference in minutes between the rows of "DateTime" column 2)I need to find the difference in minutes between the rows of "Dat...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    here is the output i see on my end from your data

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

unfortunately not in the same table, we have to create a calculated table.

Giavo's avatar
Giavo
Icon for Helper III rankHelper III
8 years ago

oh ok, it is ok then. My next step would be to SUM this minutes per each IWC Number

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago
    summ of minutes = sumx(x, [Minute Diff])

    add above measure, drop table visual with iwc number and above measure, you will have it.