Average Sum of total month

[jercks00]

Hi I would like to Average the Sum of total month from July 2023 to June 2024 , but I have data from July 2023 to July 2024 how would i do it

This is the out put that i want 

ive tried this formula but i getting by day average from July 1 2023 to June 30, 2024

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Sales: = 
SUM(sales[sales])

expected result measure: = 
VAR _t =
    SUMMARIZE (
        FILTER (
            'calendar',
            'calendar'[Date] >= DATE ( 2023, 7, 1 )
                && 'calendar'[Date] < DATE ( 2024, 7, 1 )
        ),
        'calendar'[Month Year]
    )
RETURN
    AVERAGEX ( _t, [Sales:] )

[TCatron18]

@Jihwan_Kim Is there a way to have this only apply to the row total of the matrix? For my need, I have the dates as my columns, the [branches] being the rows, and I have other measures for the values. What I'm needing to only have the average of the measures across the months display in the row grand total of the matrix. I do not want this new measure that you have provided an example for to be visible in the date columns - only the grand total.