Forecast version comparison measure

Hi adsam ,

Please check if this could meet your requirements:

Period_ Column = 
RIGHT ( [Month], 4 ) & LEFT ( RIGHT ( [Month], 9 ), 2 )

Measure =
VAR MinPeriod =
    CALCULATE (
        MIN ( Data[Period_] ),
        FILTER (
            ALLEXCEPT ( Data, Data[Release Year], Data[Releasing Period] ),
            Data[Forecast] > 0
        )
    )
VAR MaxPeriod =
    CALCULATE (
        MAX ( Data[Period_] ),
        FILTER (
            ALLEXCEPT ( Data, Data[Release Year] ),
            Data[Forecast] > 0
                && Data[Releasing Period]
                    = MAX ( Data[Releasing Period] ) - 1
        )
    )
VAR CurrentVersion =
    CALCULATE (
        SUM ( Data[Forecast] ),
        FILTER (
            ALLEXCEPT ( Data, Data[Release Year], Data[Releasing Period] ),
            Data[Period_] >= MinPeriod
                && Data[Period_] <= MaxPeriod
        )
    )
VAR PreviousVersion =
    CALCULATE (
        SUM ( Data[Forecast] ),
        FILTER (
            ALLEXCEPT ( Data, Data[Release Year] ),
            Data[Releasing Period]
                = MAX ( Data[Releasing Period] ) - 1
                && Data[Period_] >= MinPeriod
                && Data[Period_] <= MaxPeriod
        )
    )
RETURN
    IF (
        HASONEFILTER ( Periods[Date].[Month] ),
        SUM ( Data[Forecast] ),
        CurrentVersion - PreviousVersion
    )

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Hi adsam ,

Please check the attached .pbix file.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.