Forum Discussion

czuniga's avatar
czuniga
Helper III
5 years ago
Solved

Comparing GroupedBy Dates

I have a list of customers and the dates of their appointments like so:   Customer ID AptDate 111 1/1/2019 111 1/5/2019 222 2/3/2020 444 2/4/2020 555 2/5/2020 555 2/6/20...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This calculated column formula works

    =1*(not(CALCULATE(MAX(Data[AptDate (Past & Future)]),FILTER(Data,Data[Customer ID]=EARLIER(Data[Customer ID])))=Data[AptDate (Past & Future)]))

    Hope this helps.

amitchandak's avatar
amitchandak
Super User
5 years ago

czuniga , expected output is not clear . But these columns can help

 

rank Column for dates = rankx(filter(Table, [Customer] = earlier([customer]) ), [Date],,asc)


last purcahse date date = maxx(filter(Table, [Customer] = earlier([customer]) && [Date] = earlier([Date])),[Date])

  • czuniga's avatar
    czuniga
    Helper III
    5 years ago

    Tried again to explain what I'm trying to accomplish as I wasn't able to get what you suggested work. Appreciate the input though!