Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try
Sum({<[SALESDATE] = {"$(=DATE(Max([SALESDATE])-2))"}>} [Sales]/1000000)
Notice that I moved the -2 subtraction one paranthesis to the left.