Forum Discussion
Solved
Rolling 5 weeks average
Hi, I'm new to power bi, I need to calculate rolling 5 weeks average for my weekly sales data, I tried in multiple ways but I'm getting wrong output can some one help me please. below is the data I ...
@Ashish_Mathur, May I know how this DAX works
5 weeks rolling average sales = if(isblank([Sales]),blank(),AVERAGEX(DATESBETWEEN('Calendar'[Date],MIN('Calendar'[Date])-34,Min('Calendar'[Date])),[Sales]))
Please read up on the AVERAGEX() and DATESBETWEEN() functions. You'll then be able to understand the formula.
Sure Ashish