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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.