Moving Averages / Rolling Averages in Power BI DAX Tutorial (28/50)

How to calculate Moving Averages / Rolling Averages in DAX
What is Moving Average in DAX
What is Rolling Average in DAX
#PowerBI #PowerBIDax #MovingAverage
🏬 Visit our Amazon Influencer Store 🏬 : www.amazon.in/...
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 For Learners Post queries and Interact 💬 : t.me/analyticsw...
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da...

[@feelsyou111]

Excellent....to resolve smoothly without writing complete dax instead using quick measure

[@AnalyticswithNags]

Yes, you are right

[@gagansingh3481]

Your measure is awesome easily understable ....Sir

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@sumibharali4061]

Calculate (average (sale amount), datesinperiod(date column, date,-3, month)

[@AnalyticswithNags]

Check playlists of this channel and explore topics on the similar line requested by you.

[@raghugange]

Hi ,
Your Videos are really great. Thank you for this...I have one question on Measures. Suppose in one report there are two measures , one created using Quick measure option and another using New measure(Manual DAX exntry), How do I differentiate them...Also for quick measure one , how do we know which calculation is used while creating it?

[@AnalyticswithNags]

You can’t I think.

[@jananiingarshal1777]

Very well explained and I tried for 3 months rolling average and got the correct output. But getting total column as well.. please let me know how we can remove the total

[@AnalyticswithNags]

In table properties uncheck total column

[@jananiingarshal1777]

@@AnalyticswithNags Thanks for the response and let me check this option

[@swapnilsharma3767]

I have constantly followed your video and subscriber too.
I have learned SQL, PowerBI from your video. Thank you for your Hardwork.
One question, How can i filter the data as in the current example its showing data from january 2016 to April 2017. I want to show only past 5 months data in the graph.
The issue arising is after filtering past 5 months i.e. from December 2016 to April 2017 again for the month of Dec., 2016 the rolling average will be 169250 instead of 164017 because the past months are filtered but i need the 3 month rolling average for December 2016 i.e. 164017 .

[@LighthouseAnalytix]

this video may me helpful for you - showing how to create rolling average for the past 5, 6, 7 months etc depending on user selections.

[@AnalyticswithNags]

yes

[@parthgupta1683]

Thanks

[@AnalyticswithNags]

thanks , keep learning

[@mudigubbasachivalayam1368]

your videos are very helpful,
i got some issue, my date column contains month starting from july 2014 but my moving average is considering from january 2014, it is including months form january to june(it is not part of my data), can you tell me what might be the problem.

[@AnalyticswithNags]

Exclude those months in dax

[@mudigubbasachivalayam1368]

@@AnalyticswithNagsTHANKS FOR THE REPLY, CAN U GIVE A HINT HOWTO DO IT.

[@raghu4780]

l am getting values in rolling average similar to month sales, in that case how it should be over come

[@AnalyticswithNags]

Didn't understand your question.
Can you elaborate

[@prashantburman4026]

Is it possible for 3 days moving average?
please help me

[@AnalyticswithNags]

Yeah we can do it , just change the parameters

[@venkatareddykummitha5863]

do a simple average calculations

[@AnalyticswithNags]

Will do soon.
Meanwhile
You can try by changing the aggregation from sum to average

[@Ashok2293]

Can you explain about average and averagex

[@AnalyticswithNags]

Soon will make video on this