Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to write an expression like this but it is not working. Please help me with the same.
Sum({<[DIM Date.Full Date]={"$(=Max(P({<[DIM Date.Full Date]={"<$(=Max([DIM Date.Full Date]))"}>})))"}>}[Account Total Unbilled Amount])
What I want to do is to have data for the closest date even when a date is selected where there is no data.
Regards,
Manu
Can you may be share a sample of how your data looks like to offer a solution?