Replicating current month column's data to future month

Hi mohdk52 ,

According to your description, here's my solution.

1.Create a new month table, don't make relationship with the fact table.

2.In Power Query, add an index column.

3.Create a measure.

Sales Measure =
VAR _Sales =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Month] = MAX ( 'Month'[Month] )
                && 'Table'[Region] = MAX ( 'Table'[Region] )
        ),
        'Table'[Sales]
    )
VAR _Last =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Index]
                = MAXX (
                    FILTER (
                        ALL ( 'Table' ),
                        NOT ISBLANK ( 'Table'[Sales] )
                            && 'Table'[Region] = MAX ( 'Table'[Region] )
                    ),
                    'Table'[Index]
                )
        ),
        'Table'[Sales]
    )
VAR _Diff =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Month] = MAX ( 'Month'[Month] )
                && 'Table'[Region] = MAX ( 'Table'[Region] )
        ),
        'Table'[Index]
    )
        - MAXX (
            FILTER (
                ALL ( 'Table' ),
                NOT ISBLANK ( 'Table'[Sales] )
                    && 'Table'[Region] = MAX ( 'Table'[Region] )
            ),
            'Table'[Index]
        )
RETURN
    IF ( NOT ISBLANK ( _Sales ), _Sales, _Last * POWER ( 1.5, _Diff ) )

Put the new month column, the measure and Region in the matrix, get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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