Yesterday Sales

[george456]

Dear Community

I have the following set analysis:

=Max({<$(vMeasure)={<>},Date={<>}>}Date)

I need to go back one day only from this point. I have tried the minus one but I am failing to have success

Can you help

Regards

[MayilVahanan · Accepted solution]

HI @george456 

Try like below

=Date(Max(Date)-1, 'YourDateFormat')

or

=Date(Today()-1, 'YourDateFormat'))