Forum Discussion

RashmitaR's avatar
RashmitaR
Helper IV
10 years ago

Dax

Hi , I have a dataset with one of its column as date and one more as close price ,I wanted to find the average of close price for the last 7 dates present in my date column for every row.For eg ...
Need Help
Sean's avatar
Sean
Community Champion
10 years ago

RashmitaR This Measure should work... Let me know.

 

7 Day Avg =
DIVIDE (
    CALCULATE (
        SUM ( Table[Close Price] ),
        DATESINPERIOD ( Table[Date], LASTDATE ( Table[Date] ), -7, DAY )
    ),
    CALCULATE (
        DISTINCTCOUNT ( Table[Date] ),
        DATESINPERIOD ( Table[Date], LASTDATE ( Table[Date] ), -7, DAY )
    ),
    0
)

 

achinm45's avatar
achinm45
Advocate IV
10 years ago

Hi Sean,

Thanks for perspective. However dates are not contigous :)

 

BR,
Achin