EOP measure - catch the last position that is not zero
Hi,
I have a EOP measure regarding to outcome values. I would like to set the measure equal to the last populated value, when is equal to zero.
For instance, in this example, I would like to set "105" in the next positions. I have tried to write this calc rule but it didn't help... APy1StkEOPFB = if (CPy1StkEOPFB >0,CPy1StkEOPFB , CPy1StkEOPFB.last_pop)
The reason to have this need is because I am using Auto Position Query in the workbook to show only a few months but this measure is being calculated for the entire calendar. The aggregated value is showing 0 since the last position is 0.