Hi group

I have measures , I want to populate with last measure with value not 0

EX. values: 23, 45, 0, 0, 0,-23 ,7, 0, 0, 345 ....etc

I tryed:

IIF( (Date.CurrentMember,[Value])=0,
(Date.CurrentMember.PrevMember,[Value]),
(Date.CurrentMember,[Value]))

a get : 23, 45, 45, 0, 0, -23, 7, 7, 0, 345 ...etc

instead of results I want:

23, 45, 45, 45, 45, -23, 7, 7, 7, 345 ....etc

Please help!

Try a recursive expression - here's a Foodmart example:

'IIF( [Measures].[Unit Sales] = 0,
(Time.PrevMember,[Measures].[LastSales]),
[Measures].[Unit Sales])'

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

GREAT!

Thanks.


"Vlado" <vkaligari (AT) tis (DOT) hr> wrote

you can also use something like

(Tail(Filter(Descendants(Time.currentmember,[Day]),([Measures].[Unit
Sales])>0),1).item(0),[Measures].[Closing])

instead of using recursive measure


Deepak Puri <deepak_puri (AT) progressive (DOT) com> wrote

Your formula is interesting but I don't know what about [Closing] ?
If I put [Unit Sales] instead of [Closing] I get result without negative
values (in my case) and empty value in some cells.
What should I change?

Thanks.




"Prasanna" <tawargerip (AT) hotmail (DOT) com> wrote