Forum Discussion
Monthly average without accumulated
I would like to calculate the average of the monthly data obtained from some daily data. I don't want the daily accumulated data to be displayed, but to obtain the monthly average of all the data. ...
Anonymous , Try like
Avg Sales = CALCULATE(Averagex(Values('Date'[Date]) , calculate(SUM(Sales[Sales Amount]))) ,DATESMTD('Date'[Date]))
I have solved it by changing the dates of the month that was giving me problems.
Thanks amitchandak .
I got the following error when I used this measure. That's happening only during the month of september.
Do you know why I have this error?
I have solved it by changing the dates of the month that was giving me problems.