Need help - Calculate certain period only

[Archie_ZHANG]

Hi,

I write a measure to calculate monthly leavers of my company. It works ok in line chart, but my question is how to calcualte certain period only with RED BOX MARK, i.e. from 2023/2/1 to 2023/1/31 only. Please help to suggest how to modify the code, thanks!

leavers_chart =

SUMX (

    DISTINCT ( 'HC EPM'[EE ID] ),

    VAR _id = 'HC EPM'[EE ID]

    VAR _mth = 'Universal'[Current]

    VAR _PrevMth =

        CALCULATE (

            MAX ( 'HC EPM'[Amount] ),

            'HC EPM'[EE ID] = _id,

            'HC EPM'[Scenario] = "Current Fcst",

            DATEADD ( 'Calendar'[Date], -1, MONTH )

        )

    VAR _CurrMth =

        CALCULATE (

            MAX ( 'HC EPM'[Amount] ),

            'HC EPM'[EE ID] = _id,

            'HC EPM'[Scenario] = "Current Fcst"

        )

    RETURN

        IF ( _PrevMth = 1 && _CurrMth = 0, -1, 0 )

)

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...