How do I get the most recent posting date for a measure?
I have the following data. How do I get the most recent month which has posted values in a formula? (Unfortunately it doesn't correspond to the current or prior month in a nice fashion).
In English, I want to say, "Give me the sum of the plan values for all the months up to the most recent month with Posted Values".
I can't just use Max (Month), because that will give June. I tried Max (if ([Posted Values] > 0 , Month , 0)) but that just gave 0. I think my confusion is that I'm trying to use Month as a measure as well as a dimension for aggregation.
Is this a job for set analysis, or should it be fixed in the load script (and if so, how???).