Forum Discussion
Moving average in 5 day intervals
Hi
I want to figure out a moving average of sales in 5 day intervals. want to show the average of sales in the last 5 days for each day. I would then like to use this value in a line chart. Can anyone help me with a DAX formula for this?
4 Replies
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi WePowerBI ,
We can use the following measure to meet your requirement:
Measure = CALCULATE ( AVERAGE ( 'Table'[value] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) && 'Table'[Date] > MAX ( 'Table'[Date] ) - 5 ) )Then we can get the result like this,
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
BTW, pbix as attached.
Best regards,This is what I want to accomplish in Power BI. In my Power BI dataset, I have a date table and a sales table that has a date table associated with the date table. How can I achieve the same thing in Power BI?
Hi WePowerBI ,
How about the result after you follow the suggestions mentioned in my original post? Please try to unpivot the date column in power query editor if your date is multi columns.
Best regards,
