topic Re: Select previous month's value in pivot table if the value for that month is not set in App Development

Select previous month's value in pivot table if the value for that month is not set

Ax — Wed, 23 Mar 2022 14:44:40 GMT

Hi,

I have a pivot table, where [Year Month] is column and measure is 'Price'.

I would like to create an expression that uses the price for that month or the previous available price, if the price has not been set.

It should be something like this:

IF(Price > 0, Price, Select previous available price)

Thank you!

Re: Select previous month's value in pivot table if the value for that month is not set

Ax — Wed, 23 Mar 2022 18:34:47 GMT

I sort of found a solution. I can use Before(Price) to get the value in previous cell. However, this only works for the first missing value, and after that as there is no price in previous cell it does not get the number.

How can I use Before to get the number from previous cell? Or use it recursively?

Re: Select previous month's value in pivot table if the value for that month is not set

durgesh22 — Thu, 24 Mar 2022 09:37:03 GMT

This cab be done with Column reference, you may have to change you expression if new columns are added .
But for now it should work.

if(sum(Price)=0,Above(Column(1)),Sum(Price))