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
        )
    )