Forum Discussion
Venkata1858
4 years agoNew Member
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 ...
- 4 years ago
Anonymous
3 years agoNot applicable
Ashish/Venkata, would this solution work if you didn't have sales in every week but wanted to calculate rolling average regardless? Thank you
Ashish_Mathur
3 years agoSuper User
Hi,
Blanks are ignored when calculating averages.