Moving Averages (Basic)

[Greg]

Related Content:

Below are a few examples of issues related to the basic Moving Averages DAX Pattern from the eDNA resources.

Enterprise DNA Forum (Search):

Moving Average issue - Workdays Only

To me it looks like the issue is more that you are looking over every single day in the last month including weekends with this formula. It doesn’t look like it is taking into account that you only want to average up working days. Can you try something like this. I want to see if this will give you the monthly moving average but only for working days. Sales MA 1M Weekdays = VAR WorkingDays = FILTER( CALCULATETABLE( Dates, DATESINPERIOD( Dates[Dat…

Moving Average in Stacked column chart

Is there any reason why the have to be in the same visual? You can’t create difference visuals? One using the dates and the other for the summary information? That would really simplify this and be more suitable from a Power BI perspective. Here’s how to create a chart for just the summary. You need to create a supporting table that assists with the visual. Maybe you’ll get some good ideas from this mock up. First you need to create a simple table like the below which will be used as the ax…

Moving Average data not accurate there is non-working day

@hhooi I’m obviously not Sam, but the reason you are seeing this is because DATESINPERIOD (and all time intell functions) will look all the dates in the range you feed it and will see blanks as zeros. There is a way to just ignore the blanks (instead of averaging in zeros, but it will still count as a day). So going off the assumption that you wanted a 5-day moving average of just the ship weight: Need to create an index in the Shipping Table. This can easily be done in power query, but if ca…

Enterprise DNA Forum (EDNA):

Moving average not average

Likely depends on the measures # of calls. If you add in IF( ISBLANK( measure ), 0 ) in the initial formula here this should also sort it out I believe. Would have to see the actual model to truly understand it exactly as it could be for various reasons. Thanks Sam

Moving Sales average for 3 Months

You’re getting this error because quick measures required the in-built heirarchy from a date table. This is explained here. I just don’t recommend using quick measures. Learning DAX is the key. Everything you could possibly want to do is easy enough to create just by writing out DAX. Thanks Sam

Enterprise DNA TV (YouTube):

Calculate A Monthly Moving Average Year To Date (YTD) in Power BI Using DAX

Calculate A Monthly Moving Average Year To Date (YTD) in Power BI Using DAX

Calculate A Rolling Average In Power BI Using DAX

Calculate A Rolling Average In Power BI Using DAX

Showcasing Trends Using Moving Average Techniques In Power BI

Showcasing Trends Using Moving Average Techniques In Power BI

Re-Using Moving Averages - Power BI & DAX Trend Analysis Technique

Reusing Moving Averages - Power BI & DAX Trend Analysis Technique