Calculating average value for a day of a month 1 year ago

[PbiCeo]

Hello evryone,

I got correct average value for a day of a month with this Measure:(same value for a whole month)

Measure =

VAR tm = CALCULATE(SUM('table'[data]), FILTER(ALL('calendar'), 'calendar'date] <= 'calendar'[date]))

return

DIVIDE('tm', 'tabe'[NumberofDays], 0)

 
But I got worng average value for a day of a month 1 year ago with below:(not same value for a whole month)

Measure =

VAR tmly = CALCULATE(SUM('table'[data]), FILTER(ALL('calendar'), 'calendar'[date] <= 'calendar'[date]), FILTER('calendar', DATEADD('calendar'[date], -365, DAY)))

return

DIVIDE('tmly', ''tabe'[NumberofDays], 0)

How should I correct the above syntax?
Thanks in advance,

[amitchandak]

@PbiCeo ,

Try like

last year MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH)))) /CALCULATE(day(eomonth(max(Sales[Sales Date]),0)),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))

[Greg_Deckler]

@PbiCeo - Perhaps this:

Measure =
VAR tm = CALCULATE(SUM('table'[data]), FILTER(ALL('calendar'), 'calendar'date] <= EOMONTH('calendar'[date],-12)))
return
DIVIDE('tm', 'tabe'[NumberofDays], 0)

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. 

[PbiCeo]

Thank you for your qucik reply @Greg_Deckler ,

Now I tried the fomular you provided, but returned blank values on Table visiual.

What's wrong?