Issue with Calculating PM (Previous Month) Measure

Anonymous , Try using

DAX
PM Employees =
CALCULATE(
[Total Employees],
DATESMTD(
PARALLELPERIOD(Dim_Calendar[Date], -1, MONTH)
)
)

= CALCULATE(SUM(table[column]), PREVIOUSMONTH('DateTime'[DateKey]))

Hi! Anonymous 

I don't see your dax for PM. Also, a parallel period would not work here as it generates the entire previous month's dates.

You can try this - 

CM Employees =
CALCULATE(
[Total Employees],
DATESBETWEEN(
Dim_Calendar[Date],
MIN(Dim_Calendar[Date]),
MAX(Dim_Calendar[Date]) ) )

Hi Anonymous 

You can use DATEADD to shift the dates back to a month prior.

MTD Revenue =
CALCULATE ( [Total Revenue], DATESMTD ( Dates[Date] ) )

MTD Revenue PM =
CALCULATE ( [MTD Revenue], DATEADD ( Dates[Date], -1, MONTH ) )

Hi Anonymous ,

Thank you for your interest in this case.

This is the data I created to test, and I'm going to show you by calculating the ID distinct count for the specified date range for the current month (CM) and the previous month (PM).

Create a measure to calculate Count:

Count = DISTINCTCOUNT('Table (2)'[ID])

Create a measure to calculate CM:

CM = 
VAR _currentmaxday =
    DAY ( MAX ( 'Table'[Date] ) )
RETURN
    CALCULATE (
        'Table (2)'[Count],
        FILTER (
            ALLSELECTED ( 'Table (2)' ),
            'Table (2)'[Date] >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
                && 'Table (2)'[Date]
                    <= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), _currentmaxday )
        )
    )

Create a measure to calculate PM:

PM = 
VAR _currentmaxday =
    DAY ( MAX ( 'Table'[Date] ) )
RETURN
    CALCULATE (
        'Table (2)'[Count],
        FILTER (
            ALLSELECTED ( 'Table (2)' ),
            'Table (2)'[Date]
                >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 )
                && 'Table (2)'[Date]
                    <= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, _currentmaxday )
        )
    )

Select a period of dates in slicer to see the values displayed by the three measures:

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Hi Anonymous 

Solution 1: Please Try This:-

1. Total Employees: This calculates the distinct count of employees for the selected period.

Total Employees = DISTINCTCOUNT(Worksheet[Name])

2. CM Employees: This calculates the employees in the current month (January 2025, in this case).

CM Employees = 
CALCULATE(
    [Total Employees],
    DATESMTD(Dim_Calendar[Date])
)

3. PM Employees: This calculates employees for the aligned period in the previous month (01-Dec-2024 to 04-Dec-2024).(Custom Previous Month)

PM Employees = 
CALCULATE(
    [Total Employees],
    DATESINPERIOD(
        Dim_Calendar[Date],
        DATEADD(MIN(Dim_Calendar[Date]), -1, MONTH),
        DATEDIFF(MIN(Dim_Calendar[Date]), MAX(Dim_Calendar[Date]), DAY),
        DAY
    )
)

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

Hi Anonymous ,

I'm so sorry for the trouble.  I've unmarked the reply as the solution.

Best Regards,
Gao
Community Support Team