peek last value not null and put it into prior date records

[Manel222]

Hello, 

I have this data

Month	Revenue
01/02/2022	0
01/03/2022	0
01/04/2022	0
01/05/2022	0
01/01/2023	300

I want this result , when the revenue is null, it takes the last not null value, any idea how to get this result, i tried peek it didin't work

Month	Revenue
01/02/2022	300
01/03/2022	300
01/04/2022	300
01/05/2022	300
01/01/2023	300

[Vegar · Accepted solution]

You can use peek for this, but you need to make sure that your date get lloaded in the correct order.

Load 

Month

If((Revenue > 0, Revenue, Peek('Revenue')) as Revenue

Resident Data

Order By Month (Desc);

[Vegar]

@Manel222 

Did you solve your issue or do you need  more feedback on your question?