Previous Month Measures

Hi,

I am assuming that as of today August 2026, you want the "New Previous Month" to be 699 and the "Closed Previous Month" to be 822.

So I have tried the following measures 

New Previous Month 2 = VAR _PreviousDate = EOMONTH(TODAY(),-1) VAR _Month_Year = FORMAT(_PreviousDate,"MMMM YYYY") RETURN COUNTROWS( FILTER( Data, FORMAT(Data[Created On],"MMMM YYYY") = _Month_Year ) )

Closed Previous Month 2 = VAR _PreviousDate = EOMONTH(TODAY(),-1) VAR _Month_Year = FORMAT(_PreviousDate,"MMMM YYYY") RETURN COUNTROWS( FILTER( Data, FORMAT(Data[Resolution Date],"MMMM YYYY") = _Month_Year ) )

I have done a similar calculation for the current month values but havent changed anything which you have written, just done for clarity purposes.

https://drive.google.com/file/d/1SkpZ36GatgPxk3ykJlSvj1MRPnIVPpo6/view?usp=sharing

Ignore the two extra columns created in the fact table as it was done for clarity purposes. Also this might not work if the Status is Resolved and and Resolution date value in the data table is empty

 Here is another option that you can use, create a new column in your Data table that generates an offset date for each month.   (Intially was going to mention to put it in the Calendar table but because this is not an active relationship you have to added in the data table).
Offset month:

Month Offset =  VAR CurrentYear = YEAR(TODAY()) VAR CurrentMonth = MONTH(TODAY()) VAR RowYear = YEAR('Data'[Resolution Date]) VAR RowMonth = MONTH('Data'[Resolution Date]) RETURN     (RowYear - CurrentYear) * 12 + (RowMonth - CurrentMonth)

Create a measure for the Current Month, Previous Month etc.. by changing the offset date only.

Current Month = -- Create a new measure for each month you need by just changing the offset month number CALCULATE(     COUNT(Data[Case Number]),     'Calendar'[Month Offset]=-0, -- 0 Current month -1 previous month etc..         USERELATIONSHIP(Data[Resolution Date],'Calendar'[Date]))

Hi

Previous Month =
CALCULATE(
[Your Current Measure],
PREVIOUSMONTH('Calendar'[Date])
)

Make sure 'Calendar' is marked as a Date table and has an active relationship to your fact table. If your card is using a slicer or FY filter, PREVIOUSMONTH needs a continuous date context, not just a single selected month, otherwise it returns blank.

If it's still off, try DATEADD instead:

Previous Month = CALCULATE([Your Current Measure], DATEADD('Calendar'[Date], -1, MONTH))

If this helped, feel free to give it a kudos or mark it as solution, helps others find it too.

You can move the logic defining start and end dates and retrieving the relevant dates into a function for ease of reuse, and then you can use that function in both the this month and previous month measures.

DEFINE  FUNCTION Local.GetThisMonthDates = () =>   VAR StartDate =   IF(    DAY(TODAY()) = 1,    EOMONTH(     TODAY(),     -2    ) + 1,    -- If today is the 1st, use the first day of the previous month    EOMONTH(     TODAY(),     -1    ) + 1 -- Otherwise, use the first day of the current month   )   VAR EndDate =   IF(    DAY(TODAY()) = 1,    EOMONTH(     TODAY(),     -1    ),    -- If today is the 1st, use the last day of the previous month    TODAY() -- Otherwise, use today   )   VAR DatesToUse =   DATESBETWEEN(    Calendar[Date],    StartDate,    EndDate   )   RETURN    DatesToUse   MEASURE 'Measures Table'[New Cases this Month] =   CALCULATE(    COUNTROWS('Data'),    LOCAL.GETTHISMONTHDATES()   )  MEASURE 'Measures Table'[New Previous Month] = CALCULATE(    [New Cases this Month],    DATEADD(     LOCAL.GETTHISMONTHDATES(),     -1,     MONTH    ),    'Data'[status] = "Active"   ) 

I changed from a COUNT to COUNTROWS as that is a bit more efficient.

Hi,

What is the problem in that file?  In the first card visual, is the answer 180 wrong?  In the second card visual, since you are calculating a YTD figure, there is no concept of a previous month.

Hi ArchStanton​ 

I'm confused why, in your example, you use TOTALMTD but still show the monthly value instead of running FYTD value for the month. Also, if you intend to show the running amount, apply the FUNCTION 'Calendar'[Date] and not to Data[Date]. There are also future dates in your calendar table and without specifying a date or period, previous month will be based on the max date in that table. Add a column that indicates whether a date is on or before today and use that as a filter.

On or Before Today =  'Calendar'[Date] <= TODAY()

Closed Previous Month =  CALCULATE (     COUNT ( 'Data'[Case Number] ),     'Data'[Status] = "Resolved",     USERELATIONSHIP ( 'Calendar'[Date], 'Data'[Resolution Date] ),     FILTER (         ALL ( 'Calendar' ),         FORMAT ( 'Calendar'[Dates], "YYYY-MM" )             = FORMAT ( EOMONTH ( MAX ( 'Calendar'[Dates] ), -1 ), "YYYY-MM" )     ) ) 

Hi ArchStanton​ 

We would like to inquire whether have you got the chance to check the solutions provided by other users in community to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.