Forum Discussion

Harry_Tran's avatar
Harry_Tran
Icon for Helper III rankHelper III
5 years ago
Solved

7 days rolling average for missing values

Hello everyone, I need help to calculate 7 Days Rolling Average for missing data. I have MAIN table with Date, Users, Points, Categories, Subcategories, and Products columns. I also hace Calendar ta...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Harry_Tran ,

     

    Sorry for late reply. You can try a calculated column like this:

     

    index = RANKX(ALLSELECTED('CASE'[Date]),'CASE'[Date],,ASC)
     
    Result:
     

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

    Hi,

    You may download my PBI file from here.

    Hope this helps.