Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Days between dates row by row - Power query or DAX?

Hi    I have a table withproperty ref, Job number, Job description, Supplier, Date logged. We have suppliers who carry out repairs at individual properties. Sometimes they will carry out more than ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    cottrera , Try a new column like

    New column =

    var _max = maxx(filter(Table, [Property Ref] = earlier([Property Ref]) && [Date Logged] < earlier( [Date Logged] ) ),[ [Date Logged] )
    return
    datediff([Date Logged],_max, day)

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

cottrera , Try a new column like

New column =

var _max = maxx(filter(Table, [Property Ref] = earlier([Property Ref]) && [Date Logged] < earlier( [Date Logged] ) ),[ [Date Logged] )
return
datediff([Date Logged],_max, day)