Forecast

Hi jemalosa2000 ,

Please follow these steps:

1.Create a calculated column to find the tickets value.

new tickets =

IF(

    ISBLANK([tickets]),

    CALCULATE(

        SUM('Table'[tickets]),

        FILTER(ALL('Table'),DATE(YEAR('Table'[FechaMes])+1,MONTH('Table'[FechaMes]),DAY('Table'[FechaMes])) = EARLIER('Table'[FechaMes]) && 'Table'[Department] = EARLIER('Table'[Department]))

    ),

    [tickets]

)

2.Create a calculated column to find the Forecast_ticket value.

new Forecast_ticket =

IF(

    ISBLANK([Forecast_ticket]),

    CALCULATE(

        SUM('Table'[Forecast_ticket]),

        FILTER(ALL('Table'),DATE(YEAR('Table'[FechaMes])+1,MONTH('Table'[FechaMes]),DAY('Table'[FechaMes])) = EARLIER('Table'[FechaMes]) && 'Table'[Department] = EARLIER('Table'[Department]))

    ),

    [Forecast_ticket]

)

3.The final result is shown below.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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