Problem with Moving average display

[Anonymous]

Hello I have an issue with the display of moving average. The different curves are for the different site. When I have no data for one day, Power BI displays nothing for this day instead of display the average with the data of the 30 previous days.

I want some continuous curve but if I use the different Type onthe x axis, it doesn't make what I want.

Thanks 

[amitchandak · Accepted solution]

@Anonymous , what is main issue, not clear, Are you suing meausre like

Rolling 30 = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))

or

Rolling 30 = calculate(AverageX(Values('Date'[Date]),CALCULATE(sum(Sales[Sales Amount])),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))