Forum Discussion

selpaqm's avatar
selpaqm
Helper V
6 years ago
Solved

dynamic rolling average based on month slicer

I need to add dynamic rolling average, already looked for a while in this forum and could not get really what i need. it should be changed when i changed the month slicer which is added like 1,2,3,4...
Need Help
  • selpaqm's avatar
    selpaqm
    6 years ago

    amitchandak  thanks your foot steps helped me but actually I have solved it as below.

     

    3%R = DIVIDE(
CALCULATE(SUM('Order'[Order/ not ordered]),DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),-3,MONTH)),
CALCULATE(COUNT('Order'[Order/ not ordered]),DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),-3,MONTH)))

    you also find entire as solution pbix on below link.

    Solution.pbix 

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

selpaqm , Hope that month is coming from date table ?