null

[datagorillagirl]

null

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

Expected measure: =
VAR _newtable =
    ADDCOLUMNS (
        Data,
        "@HC", CALCULATE ( SUM ( Data[Ending HC] ) ),
        "@HCprevmonth",
            CALCULATE (
                SUM ( Data[Ending HC] ),
                FILTER (
                    ALL ( Data ),
                    Data[Fiscal Month ID]
                        = EARLIER ( Data[Fiscal Month ID] ) - 1
                )
            )
    )
VAR _monthcount =
    COUNTROWS ( Data )
RETURN
    DIVIDE ( SUMX ( _newtable, [@HC] + [@HCprevmonth] ), _monthcount * 2 )

[datagorillagirl]

Do you have an alternative to the earlier function as that does not work

[Jihwan_Kim]

Hi,

Please try the below, and check the attached file.

Expected measure V2: =
VAR _newtable =
    ADDCOLUMNS (
        Data,
        "@HC", CALCULATE ( SUM ( Data[Ending HC] ) ),
        "@HCprevmonth",
            CALCULATE (
                SUMX (
                    FILTER (
                        ALL ( Data ),
                        Data[Fiscal Month ID]
                            = MAX ( Data[Fiscal Month ID] ) - 1
                    ),
                    Data[Ending HC]
                )
            )
    )
VAR _monthcount =
    COUNTROWS ( Data )
RETURN
    DIVIDE ( SUMX ( _newtable, [@HC] + [@HCprevmonth] ), _monthcount * 2 )

[datagorillagirl]

It works in the pbix file but getting odd results in my measure

[Jihwan_Kim]

Hi,

Please share your sample pbix file's link.

Thanks.