Forum Discussion

villa1980's avatar
villa1980
Icon for Resolver II rankResolver II
1 year ago
Solved

Time Duration between rows

I am trying to look at the duration between the end date and next start date for each STARTDATE category. I am using the below DAX and is coming out with some weird results which I am struggling to ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    villa1980 

    since you have the index column , you can try this

     

    Measure =
    var _end=maxx(FILTER(all('Table'),'Table'[BAYDESC]=max('Table'[BAYDESC])&&'Table'[Index]=max('Table'[Index])-1),'Table'[ENDDATE])
    return DATEDIFF(_end,max('Table'[STARTDATE]),MINUTE)
     
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
1 year ago

villa1980 

what do you man by start date as a group? It is a table visual. Usually it will automatically group the column data which is text or date format.

 

villa1980's avatar
villa1980
Icon for Resolver II rankResolver II
1 year ago

That is fine, think I was just trying to over think it, I just need to highlight if is less than 60 and then calculate form that, is fine.

Thank-you once again

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

    you are welcome