Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to adjust the expression for my KPI, which is currently:
Sum({<[Category] = {'Direction'}, [Date] = {'3/1/2018'}>} [Value])
I hard-coded the date in the expression, but that's not what I want. What I want is the following:
If a selection is not applied, I want the default selection to be the max Date. However, if a Date selection is applied, then I want that to show on the KPI.
The data set is attached.
Thanks!