How to calculate previous date

[abc_18]

Hi,

I have below expression for the current date column which is working fine, have to calculate previous date for another column.

=sum(if(DT.Date = aggr(nodistinct max(DT.Date),measure),qty))

I tried using below expression for previous date but it's not working , can someone help me with the correct way?

=sum(if(DT.Date = aggr(nodistinct date(max(DT.Date)-1,'MM/DD/YYYY'),measure),qty))

[Andrew_Delaney]

What do you get when you use your current formula for previous date?