Rolling MAT Graphs

[CEEGEE_CEEGEE]

Hi there,

I'm kind of stuck up with this graph. Appreciate if you have any workaround that you can suggest.

I'm trying to show a MAT figures for a rolling graph. However, it seems that the DAX that I've used only computes for the YTD figures.

In the picture, the 2024 figure should be around 6.67, same goes for 2022, and 2023 (should be around 6.60+)

And this is also the DAX that I've used for the above graph:

Rolling Volume Sticks MAT =

    var MaxDate = MAX(Dates[Date].[Date])

    var MaxEndDate = EDATE(MaxDate,12)

    var Result =

    if(

        HASONEVALUE( 'Presentation Calendar'[Date].[Year] ) &&

        max( 'Presentation Calendar'[Date]) <= MaxEndDate &&

        min( 'Presentation Calendar'[Date]) <= MaxDate,

        CALCULATE([MAT Volume Sticks]/1000000,

        FILTER( ALL(Dates[Date].[Year]),

        'Dates'[Date].[Year] = VALUES( 'Presentation Calendar'[Date].[Year] ) )

        ),

        BLANK()

    )

    Return

    Result

This is the DAX that I've used to compute for the MAT figures:

MAT Volume Sticks =

calculate([Volume Sticks bn],DATESINPERIOD(Dates[Date].[Date],LASTDATE(Dates[Date].[Date]),-12,month))

Thanks

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...