Need help - Calculate certain period only

Archie_ZHANG — Tue, 13 Feb 2024 01:58:52 GMT

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 )

)

Re: Need help - Calculate certain period only

lbendlin — Tue, 13 Feb 2024 21:24:10 GMT

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-Forum/ba-p/963216

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/1447523

topic Need help - Calculate certain period only in DAX Commands and Tips

Need help - Calculate certain period only

Re: Need help - Calculate certain period only