Columns containing average value the current month[latest month in data source]& the previous month

Hi All,

Below is my input source table :-

We have a aggregate calculated table with columns as  [Category],ParamScores[measures of the average and percentage column in source table] and Currentmonth as shown below.

NewTable = 
GENERATE (
    SUMMARIZE (
        SELECTCOLUMNS (
            'Table',
            "CurrentMonth", FORMAT ( 'Table'[AuditDate], "MMMM - yyyy" )
        ),
        [CurrentMonth]
    ),
    ADDCOLUMNS (
        DATATABLE (
            "Category", STRING,
            {
                { "AverageScore" },
                { "AveragePercentage" }
            }
        ),
        "ParamScore",
            VAR _m = [CurrentMonth]
            RETURN
                IF (
                    [Category] = "AverageScore",
                    FORMAT (
                        CALCULATE (
                            AVERAGE ( 'Table'[Score] ),
                            FORMAT ( 'Table'[AuditDate], "MMMM - yyyy" ) = _m
                        ),
                        ""
                    ),
                    FORMAT (
                        CALCULATE (
                            AVERAGE ( 'Table'[PercentageStudents] ),
                            FORMAT ( 'Table'[AuditDate], "MMMM - yyyy" ) = _m
                        ),
                        "0%"
                    )
                )
    )
)

Present Output:

Expected Output:

Assume in our sample data :  Current Month year is September 2021 and PreviousMonthYear is August 2021.

 I want to see the output as above.

[What modifications, is needed to my script to achieve this ?] or any other changes or new script. please suggest.

Kind regards

Sameer