topic Re: Average Sum of total month in DAX Commands and Tips

Average Sum of total month

jercks00 — Fri, 16 Aug 2024 03:50:11 GMT

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

Re: Average Sum of total month

Jihwan_Kim — Fri, 16 Aug 2024 04:53:29 GMT

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

Re: Average Sum of total month

TCatron18 — Wed, 02 Apr 2025 19:25:55 GMT

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.