To Get Last 12 months Visit Date

[nagesh]

Hi All,

I have a Date Column called VisitDate, As per my requirement i have show Visitdates for last 12 months how many times customer has visited .

Any help.

Thanks...

[Vegar · Accepted solution]

Try this expression

=sum({<
  VisitDate = {">$(=addmonths(max(VisitDate),-12))<$(=max(VisitDate))"}
>}NoOfVisits)