Calculate MOVING AVERAGES using DATESINPERIOD DAX Function // DAX Basics Guide in Power BI

Get Demo Files here

In this video were going to cover how to the DATESINPERIOD DAX function to calculate moving averages very easily in Power BI.

Link to Documentation

-

🚩 Get Demo Files here

👍 Become a Patreon to support the channel and get free perks!

🛍 Get exclusive templates built using best practices here

❤ Other ways to support

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[CarlosPadilla-ptzw]

I spent MONTHS looking for this solution!!! I'm still a DAX rookie. Thankyou Very Much!!!

[ItsWithinYou]

Very easy to follow your teaching! Many thanks for your time and effort!

[alanm]

Thanks for this. Nice straightforward explanation !

[Adeyeye_seyison]

Thanks for all you do and represents sir Fernan

[gintomino]

Very useful and easy to learn! Thank you for sharing your knowledge!!! :)

[looksee]

Nice and concise, thank you ❤. A simple divide is perfect. I tried to use AVERAGE in place of SUM (may data has only 1 entry per month) - but it returned same as SUM ??? Can you explain why Average doesnt work here?

[sonikusum]

Thank you for great clarity in rolling average! How can it be achieved by using AverageX function with DatesInPeriod?

[toufikel]

hello. Thanks for this vidéo.
with this function, can we compare vs 1st January for example?

[SimonM-blpq]

Hey, thank you for all of that! But where did you get the Year / Month column from? Cannot find the description how to group to this column :(

[specialblend]

Thanks so much for this, helped tremendously! Was struggling with a "Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column" error when attempting to use the Quick Measure function previously.

[shahnidk]

Hi, nice one. Have a doubt like for jan 2020 and feb 2020 we don’t need to divide by 3 months. How to do it. Can we make it dynamic count of month.

[sung]

what are the moving average numbers for February 2020 & January 2020 here ? How did they come about when there is no data from 2019 to calculate the moving avg backwards?

[SaiDineshSindiri]

Hello Fernan.
For January month we don't have values for previous two months and while calculating moving average you took value as 3 for dividing is this correct approach?

[ajay]

Can you explain why we are using max date

[predatorab]

Hi and thank you for the video!!
Please can you show how to calculate a monthly average based on the monthly values of last 5 years.
For example: July 2023 value =

Thanks!!!

[RehanShaikh-iphh]

Thanks.
How to make measure for moving average with selected calendar slicer.

[gintomino]

I watched this a lot of times coz it’s so useful for my work. But what if the start date is from last month? Pls help thanks

[gbcsupplychain]

Great video thanks so much for this! I have tried the formula on excel power pivot ( not Dax) but it it came up with error mdsscript 6, 73 cannot convert value " of the text to numeric. I wonder if u have this type of error before and how did u resolve it? Thanks!

[amitsawant]

Hi,
I have created a Matrix chart in power bi, which has last 5days date as column, departments as rows and sales data as values. I want a single column to display average of my sales in a single column for each row to check what is the average sales in last 5 days for that particular department. Please make a video on this ASAP

[sachinkumart]

Hi sir is there any possibility of by selecting April month the previous 3months average should be shown. Kindly please 🙏 me with this