How to creating rolling average for last 6 months using period slicer,

[RDN_03]

Getting correct for last 6 mnths as per below measure but my rolling average giving wrong values.

Last6mnths_rcvd =

VAR Referencedate =MAX(Dates[Date])

VAR Previousdates = DATESINPERIOD(Las6mnthsTabble[Date],

Referencedate,-6,MONTH

)

VAR Result= CALCULATE([Total_received],

REMOVEFILTERS(Dates),

KEEPFILTERS(Previousdates),

USERELATIONSHIP(Dates[Date],Las6mnthsTabble[Date])

)

RETURN

Result

above is correct  for last 6 mnths .

below measure for rolling average 

rolling average last 6 mnths =

VAR Referencedate =MAX(Dates[Date])

VAR Previousdates = DATESINPERIOD(Las6mnthsTabble[Date],

Referencedate,-6,MONTH

)

VAR Noofmnths=6

VAR Rolling= CALCULATE([Total_received]/6,DATESINPERIOD(Dates[Date],LASTDATE(Las6mnthsTabble[Date]),-Noofmnths,MONTH),

REMOVEFILTERS(Dates),

KEEPFILTERS(Previousdates),

USERELATIONSHIP(Dates[Date],Las6mnthsTabble[Date])

)

RETURN

Rolling

where im going wrong.. my correct value for average shoudl be as below

@amitchandak pls help

[amitchandak]

@RDN_03 , if date join is active it should be simple like

Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-6,MONTH))

else use a measure which already using use relationship

Rolling 6 = CALCULATE([Your Measure],DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-6,MONTH))

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f

Rolling Months Formula: https://youtu.be/GS5O4G81fww

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[RDN_03]

above is my 1 year sample data, I could achieve the above, where iam removing edit interactions from period and unfiltering for last 6 mnths & visual is static , requirement is it should be dynamic where based on the period selection I need to show last 6 months sales & last 6 months average (example if i select jan24 , it should display last 6 months sales & last 6 mnths average).

Pls guide @amitchandak