Measure is taking long time

Hi anusha_2023 ,
The issue lies in the use of CALCULATE inside EOMONTH, which can significantly slow down performance. This happens because it evaluates the entire table repeatedly.

you can try to use variables like bellow measure:

Hour Rolling Months Matrix Measure 2 =
VAR MaxVoucherDate =
    CALCULATE(
        MAX(RevenuePerHourView[VoucherDate]),
        RevenuePerHourView[TotalQuantity] > 0
    )
VAR TargetDate = EOMONTH(MaxVoucherDate, -1)
RETURN
    CALCULATE(
        SUM(RevenuePerHourView[TotalQuantity]),
        DATESINPERIOD(
            'Date'[Date],
            TargetDate,
            -SELECTEDVALUE(RollingMonthsParameter[RollingMonthsParameter]),
            MONTH
        )
    )

Hi anusha_2023 - can you please try the below approach and also test it via performance analyzer.

Hour Rolling Months Matrix Measure 2 =
VAR FilteredTable =
FILTER(
RevenuePerHourView,
RevenuePerHourView[TotalQuantity] > 0
)
VAR RefDate =
MAXX(
TOPN(
1,
FilteredTable,
RevenuePerHourView[VoucherDate], DESC
),
RevenuePerHourView[VoucherDate]
)
RETURN
IF(
ISBLANK(RefDate),
BLANK(), // Handle case where no valid Reference Date exists
CALCULATE(
SUM(RevenuePerHourView[TotalQuantity]),
DATESINPERIOD(
'Date'[Date],
EOMONTH(RefDate, -1),
-SELECTEDVALUE(RollingMonthsParameter[RollingMonthsParameter]),
MONTH
)
)
)

The above optimized version above refines it slightly for edge cases and readability.

Hope this helps.

There doesn't seem to be much goin on with your measure. Now, how granular is the data in your viz?