Download the file ⬇ - goodly.co.in/how-calculate-moving-averages-power-bi/ Create insightful calculations using CONCATENATEX - th-cam.com/video/xVLi31mOxeo/w-d-xo.html Also, check out the Hindi Channel - www.youtube.com/@desigoodly/videos
Wow, how crazy is this! Just when I needed this you make a video about it. You are not only good at power bi (explaining), you can also read minds. Thanks for all your super interesting videos. 🙏👊
Hi @Goodly Chandep, thanks for the video. I am trying to wrap my head around the Moving Avg Check. 7:52 What happens if the datesinperiod is the referenced table in the summarize function? Rather than having the datesinperiod as a filter table. While I'll check the result myself, your view as a specialist would be appreciated.
Thanks, I learned a lot from your tutorial video. I need help to do the same but in 4 weeks rolling average based on ISO workweek. Appreciate your advice!
@GoodlyChandeep this video is awesome and I was able to get my three month moving average. Do you have any recommendations for restarting the average every calendar year but not including the previous years spend? thsank you for your help!!!!
This is amazing! How would you modify this code so that the calculation of the averages start afresh after a certain number of months. Say we have a 12 month rolling average. Once we hit the new year, it should start again without considering any of the previous year's values?
Just Brilliant 😮👍👏 And also love the application of concatnetax function .. I think you can make a second video on this function 😊 Recently I saw someone use this to highlight top 3 and bottom 3 customers Name and sales updated against each month row in matrix table.
Interesting method, I've noticed before you prefer to divide to get an average rather than iterate over a table of whatever, also Im never sure with an average in on a monthly gain, should it be total of Jan , feb / 2 or the average of Jan and feb / 2 , as said I would have just done Max date and Edate -3, so I shall download and work through.
This has come timely as a solution i was looking for in PBI and that too dynamic selection completely covered the bonus too. However, this is half of the overall reporting:analysis requirement iam exploring to built. I want to create more measures to derive few more Outcomes- with 6MVA , same as immediate Previous month, Same as same month previous year,3MVA based on Lag 3( eg.If October, then 3MA of May,Jun,July). Now once we have these outcomes based on the various measures, want a final conclusion which outcome is closer to that particular months sales and provide its name in the separate measure/column. Look forward with your creative solution as always 😊.
Great video. easy to understand language and easy to understand the logic. we can create dynamic rolling moving average. I want to calculate moving average based on MTD. e.g. 03/03 it calculate moving average based on last 3 days i.e 28/02,01/03,02/03 and on 04/03 it calculate moving avg. of 01/03,02/03 and 03/03 and so on ?
10:21 At this moment while I select [total Sales] , it will not retrieve individual month sales , instead of it it returns the total of those three months Can any one help on it
How can i make the moving average stay the same for future months? I want my moving average to replicate month over month for example for my entire month table.
Imagine a scenario where the total amount were for several products and I would like to use data segmentation to see the moving average being calculate as I change the filter/segmentation. How could I do it?
Sir...pls help Sir, while click on content... Detail displayed but file name column remove.... How to fix the problem... I am extract csv format file through power query
I have a disconnected slicerdate for dynamic axis of no.of months and from Total sales it is not working for me. Though I have calculated total sales using userelationship
Hi, it worked fine till Concatenating Year | Month in check measure. Later when I'm changing it to TOTAL sales measure, it is giving only current month value and remaining only + are visible. Eg: 1st row 856, 2nd row "+ 758 +", 3rd row " + + 457" like that. I removed Total Measure and gave Sum(Sale QUantity) in Concatenatex formula then it is giving same value (current month value) in all 3 places, like 856, 758+758, 457+457+457. What might be going wrong here?
I noticed at ~10:00 the moving average check seems to have a glitch for year 2011. Jul is listed instead of May (starting three lines in a row),which appears to happen again for the following year 2012 data. What would cause this to occur? I will download and check, but noticed this in the video. Once again you provided good content .
Lets say I need to show moving 12 months of average, but the user wants to show only 12months of data points in the chart, not all the months present in the dataset. Of course will have to apply a filter so that the chart shows only 12months. In this kind of scenario these calculations will not work!😢
Zipping a single file is unnecessary - most Microsoft files are already compressed and typically take the same amount of disk space as the Zip file. All it does is make it more inconvenient to access the file itself. Even at legacy modem speeds it hardly makes any difference.
Download the file ⬇ - goodly.co.in/how-calculate-moving-averages-power-bi/
Create insightful calculations using CONCATENATEX - th-cam.com/video/xVLi31mOxeo/w-d-xo.html
Also, check out the Hindi Channel - www.youtube.com/@desigoodly/videos
Chandeep... you are really an inspiration for an upcoming trainer. you make things easier and simpler.
Bro you are my god father from your video I learn alot... And my child will learn also in future
I really wish our children have something better to do than Power BI 😄
Wow, how crazy is this! Just when I needed this you make a video about it. You are not only good at power bi (explaining), you can also read minds.
Thanks for all your super interesting videos. 🙏👊
Great video, simply explained and with useful content, keep up the amazing work!
Brother, that was so cool, man. Thanks for this. Defintly opened my opened my eyes on my existing reports
This is equivalent to pressing F9 in Excel. Amazing video!
Super clear explanation! Thank you!
Hi @Goodly Chandep, thanks for the video.
I am trying to wrap my head around the Moving Avg Check. 7:52 What happens if the datesinperiod is the referenced table in the summarize function? Rather than having the datesinperiod as a filter table.
While I'll check the result myself, your view as a specialist would be appreciated.
This is awesome as usual, thanks Chandeep
Thanks, I learned a lot from your tutorial video. I need help to do the same but in 4 weeks rolling average based on ISO workweek. Appreciate your advice!
This was excellent. Once I got my months sorted right it worked. Thanks!
Great video! Very clear to follow. I wonder if it is possible to calculate rolling Z-scores in Power BI as well
Waiting
what an amazing tutorial on moving averages with a validation caviar. thanks so much
Amazing tutorial Chandeep! Your videos are amazing as always. Thanks for sharing your wisdom with us.
Awesome trick! Thank you
Amazing tricks as always! Keep going Dax. Thanks.
Hello, what other alternative can you I use for the Datesinperiod?
Video is very much help full for knowledge seekers like me, thank you bro.
@GoodlyChandeep this video is awesome and I was able to get my three month moving average. Do you have any recommendations for restarting the average every calendar year but not including the previous years spend? thsank you for your help!!!!
Brilliant!!! Thank you.
This is amazing!
How would you modify this code so that the calculation of the averages start afresh after a certain number of months. Say we have a 12 month rolling average. Once we hit the new year, it should start again without considering any of the previous year's values?
Just Brilliant 😮👍👏 And also love the application of concatnetax function .. I think you can make a second video on this function 😊 Recently I saw someone use this to highlight top 3 and bottom 3 customers Name and sales updated against each month row in matrix table.
Excellent 🎉.. specially the last one. Thanks for sharing 👍
Interesting method, I've noticed before you prefer to divide to get an average rather than iterate over
a table of whatever, also Im never sure with an average in on a monthly gain, should it be total of Jan
, feb / 2 or the average of Jan and feb / 2 , as said I would have just done Max date and Edate -3,
so I shall download and work through.
It's looks amazing
Really Really amazing!!!!
😮😮😮❤❤❤❤❤
Gracias, el video me ayudó a resolver un pedido.
What an amazing guy he is.
This has come timely as a solution i was looking for in PBI and that too dynamic selection completely covered the bonus too.
However, this is half of the overall reporting:analysis requirement iam exploring to built.
I want to create more measures to derive few more Outcomes- with 6MVA , same as immediate Previous month, Same as same month previous year,3MVA based on Lag 3( eg.If October, then 3MA of May,Jun,July).
Now once we have these outcomes based on the various measures, want a final conclusion which outcome is closer to that particular months sales and provide its name in the separate measure/column.
Look forward with your creative solution as always 😊.
What can be the solution way to address the dataset with huge sales and have different products and locations in the table. How will it be addressed?
Thanks, very helpful.
But what about totals? And what if I want to calculate averages for next 3 months and how to add YTD/YTG for totals?
Amazing g , can we show 2 moving averages in the chart.?
Great video. easy to understand language and easy to understand the logic.
we can create dynamic rolling moving average. I want to calculate moving average based on MTD. e.g. 03/03 it calculate moving average based on last 3 days i.e 28/02,01/03,02/03 and on 04/03 it calculate moving avg. of 01/03,02/03 and 03/03 and so on ?
@Goodly man this is insanely good. Thanks for the vid!
Thank you so much for this.. you are a life saver❤❤❤
the check measure is excellent with the dynamic parameter participate in.
excellent sir
Very helpful
Simply beautiful, I can't wait to replicate it.
10:21 At this moment while I select [total Sales] , it will not retrieve individual month sales , instead of it it returns the total of those three months
Can any one help on it
Absolutely awesome 👌 👏
I'm stuck at where the MIndex came from. Is it a column assigning the numeric order to the months?
How can i make the moving average stay the same for future months?
I want my moving average to replicate month over month for example for my entire month table.
Imagine a scenario where the total amount were for several products and I would like to use data segmentation to see the moving average being calculate as I change the filter/segmentation. How could I do it?
very impressive Sir
brilliant! many thanks
Sir...pls help
Sir, while click on content... Detail displayed but file name column remove.... How to fix the problem... I am extract csv format file through power query
You're a magician bro.
Amazing 🔥
Goodly is amazing!
Pretty awesome....as always
I am unable to move beyond the Calculate Total Sales step as the Calculate function is not taking the total sales as the input
its Superb!!
incredible sir
I have a disconnected slicerdate for dynamic axis of no.of months and from Total sales it is not working for me. Though I have calculated total sales using userelationship
This is amazing.
Outstanding !!!
Hi, it worked fine till Concatenating Year | Month in check measure. Later when I'm changing it to TOTAL sales measure, it is giving only current month value and remaining only + are visible. Eg: 1st row 856, 2nd row "+ 758 +", 3rd row " + + 457" like that. I removed Total Measure and gave Sum(Sale QUantity) in Concatenatex formula then it is giving same value (current month value) in all 3 places, like 856, 758+758, 457+457+457. What might be going wrong here?
Awesome awesome ... this so great..
I want to get the average, standard deviation, etc, but for only the last 30 data points (not days), is
it possible?
Use the TOPN function to get the first N values from the table and then aggregate over it.
Yes, more DAX please!
You Rock!... Thanks a Lot
was wondering how you can stop the chart from showing future values
That’s cool bro !!! ✌
THNX A LOT!!!
You are awesome 👌
You are master ❤😊
Super 👍👍👍
I noticed at ~10:00 the moving average check seems to have a glitch for year 2011. Jul is listed instead of May (starting three lines in a row),which appears to happen again for the following year 2012 data. What would cause this to occur? I will download and check, but noticed this in the video. Once again you provided good content .
Men that was amazing
If any of the month sales is zero can we skip that month.
You can use Window function to obtain the same result
denominator could be simplified via this: VAR Mon = QUOTIENT(COUNTROWS(Period),28)
finished watching
a big thanks
Awesome
Lets say I need to show moving 12 months of average, but the user wants to show only 12months of data points in the chart, not all the months present in the dataset. Of course will have to apply a filter so that the chart shows only 12months. In this kind of scenario these calculations will not work!😢
❤❤
❤
Zipping a single file is unnecessary - most Microsoft files are already compressed and typically take the same amount of disk space as the Zip file. All it does is make it more inconvenient to access the file itself. Even at legacy modem speeds it hardly makes any difference.
your query are too complex
Hi.. excellent..need help with few queries..how can i contact you chandeep
Is really good but in my case last month under tooltip detail 2nd month value coming zero like (123+ 00 + 545)/3
❤