Forum Discussion

Jorgast's avatar
Jorgast
Icon for Resolver II rankResolver II
5 years ago
Solved

Find previous date based on single date per record.

Hello Power BI Community   I need your help.  What I want to do is compare the current row data and find the previous date a case was submitted for the same account number. If the data is the 1st c...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Jorgast , Previous date as a new column

    MAXX(Filter(Case, Case[ID] = EARLIER(Case[ID]) && Case[Created_Date] <earlier(Case[Created_Date])),Case[Created_Date])

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

Jorgast , Previous date as a new column

MAXX(Filter(Case, Case[ID] = EARLIER(Case[ID]) && Case[Created_Date] <earlier(Case[Created_Date])),Case[Created_Date])