Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement were I need to show the last 6 dates in a list box. I have tried to display the same using a formula as below the
The expression is as below:
but this does not appear to be producing the expected results. I am just getting an empty list box.
Please suggest.
may be can you try like this
=If(Match([Run Date], $(=Max({1} [Run Date])), $(=Max({1} [Run Date]))-1,$(=Max({1} [Run Date]))-2),[Run Date])