Hello,
I have a unique requirement here. I have a filter for dates and applied an alternate state 'Current' for this filter. So this filter will operate in the 'Current State'.
I have written an expression like 'Sum({[Current]}Value)' to get the values for the date selected in this filter. Now challenge for me here is to create another column next to it, which would give me the values for previous date of the one selected in filter. I would have used 'Above' function to get the previous date, but the Alternate state is creating a problem here.
Can anyone suggest a fix to resolve this here?
