Help with Median

Hello katari_123,
Thank you for reaching out to the Microsoft Fabric Forum Community.

I’ve reproduced your scenario in Power BI and achieved the expected 3-month rolling median result. For example, for the MONTH_END of June 2025, the median correctly calculates as 157, using the values from April to June 2025 exactly as you described.

What I did:

• Created sample data for MONTH_END and VALUE.
• Built a separate Date table and linked it to the MONTH_END column.
• Used the following DAX measure to calculate the 3-month rolling median:

R3M Median Value =

VAR CurrentDate = MAX ( 'Date'[Date] )

VAR Period =

    DATESINPERIOD (

        'Date'[Date],

        CurrentDate,

        -3,

        MONTH

    )

RETURN

CALCULATE (

    MEDIAN ( R3M[VALUE] ),

    FILTER (

        ALL ( 'Date' ),

        'Date'[Date] IN Period

    )

)

Expected output:

I’m attaching the .pbix file for your reference so you can explore the full solution and adapt it to your dataset.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.