Dax Formula

[nazim]

Hi All,

I am using the below code

=CALCULATE (    average(Test1[Amount]) ,
    DATESBETWEEN (
        DimCalendar[Date],
        LASTDATE ( DimCalendar[Date] ) - 2,
        LASTDATE ( DimCalendar[Date] )
    )
)

to get last 3 days moving average. The problem it is taking the running average as per the data table, but i need the average to be as per the pivot table selection.

Would really appreciate your help.
Thanks
Nazim

<tbody>
</tbody>

 

[Matt Allington]

Your formula looks fine. Do you have the right date column in your pivot table? Ie from the calendar table and not the data table?