Set Analysis Expression Issue

[Anonymous]

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

[sunny_talwar]

Can you may be share a sample of how your data looks like to offer a solution?