Date expression

[niranjana]

Hi, I have a situation where I have date field "Movement date" in the date format "19/09/2023".  i need to calculate count of claims.

I wrote this expression :

" count({$<[Movement Date]={"= $(Date(max([Movement Date])-1),'DD/MM/YYYY')"}>}[Claim Number]) " .

I also tried this expression : "count({$<[Movement Date]={"= $(=max([Movement Date]))"}>}[Claim Number])"

The expression shows ok, but the result is 0,  or it doesn't show any result. The count must show as 2258.

Any help is appreciated.

Thanks in advance,

Niranjana

[justISO · Accepted solution]

Hi, try this:

=count({$<[Movement Date]={"$(=(Date(max([Movement Date])-1,'DD/MM/YYYY')))"}>}[Claim Number])

[niranjana]

HI , Thanks a lot!! It worked..is it because of bracket?

[justISO · Accepted solution]

I changed 2 parts, bracket place and this '{"= $(' part to '{"$(=(, but I don't know which change corrected the formula. I'll probably never learn to write set analysis correctly, so I always have a few examples saved to check syntax which works 🙂

[niranjana]

Thanks  a lot! same issue is there...that of brackets.....ur explanation and having syntaxes is bang on!