Forum Discussion

Imthedan's avatar
Imthedan
Icon for Helper II rankHelper II
5 years ago

Getting a rolling average based on total vs. total days?

Hello,

I am trying to get a simple average that is based on how many days have been ran in my time period. I'd want to get 177 divided by 4 (since there have been four Fridays). Since five total Wednesday's have been ran, I'd want to get the total of Wednesday divided by 5. 

 

I need this to be a rolling average as well, so it updates based on the calendar updating. 

 

Thank you for your help!

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Imthedan , Isincope should help

     

    assume you have measure then try like

     


    Sub Total= calculate(averagex(values(Date[Date]),[measure]) ,filter(allselected(Date), Date[Day Name] = max(Date[Day Name])))

     

    FInal measure = if(isinscope(Date[Day Name]) && not(isinscope(Date[Date])), [Sub Total], [Measure])

    • Imthedan's avatar
      Imthedan
      Icon for Helper II rankHelper II
      5 years ago

      I put in the code and got an error saying the filter function passed too few arguments. 

       

      Here is the code I used: 

       

      Sub Total = CALCULATE(AVERAGEX(VALUES(LU_Calendar[Date]),[Total_Test]),FILTER(ALLSELECTED(LU_Calendar[Date],LU_Calendar[Day Name] = MAX(LU_Calendar[Day Name]))))
       
      Do you see the issue?
       
      Thank you!