Need Help: Rolling Average (Last 2 days) | When multiple dates in a column

[ketan10]

I have an original table using which I need to calculate the rolling average of rating table. However I do not get the expected output. Can somebody please help me with a DAX solution for this ? 
Please refer the image below:

Any help would be appreciated !

[rabih]

I replicated your data and chose Average of Rating instead of Sum or Don't summarize etc..

[Zubair_Muhammad · Accepted solution]

Hi @ketan10

Try this MEASURE

Rolling 2 Days Average =
AVERAGEX (
    TOPN (
        2,
        FILTER (
            ALL ( TableName[Date] ),
            TableName[Date] <= SELECTEDVALUE ( TableName[Date] )
        ),
        TableName[Date], DESC
    ),
    CALCULATE ( AVERAGE ( TableName[Rating] ) )
)

[Zubair_Muhammad]

@ketan10