Forum Discussion

MWare's avatar
MWare
Icon for Helper I rankHelper I
3 years ago
Solved

DAX Calculation to retrieve the entry before

Hi,   Looking for some help please.   I am trying to return the previous 'Sale time' based on the 'Sales Person' of each row in my 'Sales' table. Unfortunatley the index is based on all sales in...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    =MAXX(FILTER(Sales,Sales[Sale Person]=EARLIER(Sales[Sale Person])&&Sales[Sale Time]<EARLIER(Sales[Sale Time])),Sales[Sale Time])

MWare's avatar
MWare
Icon for Helper I rankHelper I
3 years ago

Perfect! thank you very much!