minus two days from max(date)

[gnmq]

Hello,

I need urgent help with the following:

=> I need to show latest date data in chart by default 

Currently, I want to show latest date - 2 days of data in chart using set analysis:

Sum({<[SALESDATE] = {"$(=DATE(Max([SALESDATE]))-2)"}>} [Sales]/1000000)

So my data should show i.e. Max(SalesDate) = 27 Mar 2019

The latest date returned should be 25 Mar 2019..

The expression above did not work for me. May I know how I can approach this? Note that I am not using autocalendar (can't create because it didn't detect the field as date).

Seems like the formula above doesn't allow the chart to be filtered to show other days' data:

This is the existing expression which works but is based on max(date)

Sum({<[SALESDATE] = {"$(=Max([SALESDATE]))"}>} [Sales]/1000000)

[Vegar]

Try

Sum({<[SALESDATE] = {"$(=DATE(Max([SALESDATE])-2))"}>} [Sales]/1000000)

Notice that I moved the -2 subtraction one paranthesis to the left.