last month total calculation divided by 3

[WNelson]

Help! I need to find the rolling totals for last month then divide that number by 3.  This will help me find a target for number of client QA calls I need to do, as they are based on a call every 3 months.  Can some one help me with a DAX.  I am using a dateTable.  

[WNelson]

This is what I am struggling with:

TARGET =

  VAR __EndDate = MAX('DateTable'[Date])

    VAR __3MonthsAgo = EOMONTH(__EndDate, -3)

    VAR __StartDate = DATE(YEAR(__3MonthsAgo), MONTH(__3MonthsAgo), 1)

    VAR __Table =

        SUMMARIZE(

            FILTER(ALL('DateTable'),[Date]>=__StartDate && [Date]<=__EndDate),

            'DateTable[Month],

            "__Value",SUM('Funder Total by month'[Total])

        )

RETURN

    AVERAGEX(__Table,[__Value])

The purple is in error.  I am not sure what to do. 

[WNelson]

@Greg 

This is what I am struggling with:

TARGET =

  VAR __EndDate = MAX('DateTable'[Date])

    VAR __3MonthsAgo = EOMONTH(__EndDate, -3)

    VAR __StartDate = DATE(YEAR(__3MonthsAgo), MONTH(__3MonthsAgo), 1)

    VAR __Table =

        SUMMARIZE(

            FILTER(ALL('DateTable'),[Date]>=__StartDate && [Date]<=__EndDate),

            'DateTable[Month],

            "__Value",SUM('Funder Total by month'[Total])

        )

RETURN

    AVERAGEX(__Table,[__Value])

The purple is in error.  I am not sure what to do. 

[WNelson]

@Greg_Deckler 

Maybe this will better explain what I am needing.  I have the gauge to sho the number of QA calls that were done this month.  I would like the target to show the number of call that should be done.  We generally call our clients eveery 3 months.  So if I can see the average number for the last 3 months and then divide that total by 3 (every 3 months), I can find my targeet.  

[Greg_Deckler]

@WNelson Use this: Better Rolling Average - Microsoft Fabric Community Just replace AVERAGE with SUM for a total instead of an average.