To compare rolling forecast of current and previous month.

[hongyuliu]

Hello,

I want to compare rolling forecast of January and Febuary for each product and company. I need a new column, raw data and result should be like following:

Can you please instruct how to write the formula?

Thank you

[v-nuoc-msft · Accepted solution]

Hi @hongyuliu 

For your question, here is the method I provided:

Here's some dummy data

"Table"

Create a column.

New Column (Previous Forecast) = 
IF('Table'[Date of Update] <> MIN('Table'[Date of Update]),
CALCULATE(
    VALUES('Table'[Value]), 
    FILTER(
        ALL('Table'), 
        'Table'[Product] = EARLIER('Table'[Product]) 
        && 
        'Table'[Forecast Month] = EARLIER('Table'[Forecast Month]) 
        && 
        'Table'[Date of Update] = MIN('Table'[Date of Update])
    )
),
BLANK()
)

 Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hongyuliu]

Hello,

I want to compare rolling forecast of January and Febuary for each product and company. I need a new column, raw data and result should be like following:

Can you please instruct how to write the formula?

Thank you