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

[@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

[@nidhianildeshpande969]

Can you please explain what value is Total Sales in calculate function in first expression

[@nidhianildeshpande969]

For me in quick measure base is showing as count of column name can you please help out

[@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

[@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.

[@parthgupta1683]

Thanks

[@AnalyticswithNags]

thanks , keep learning

[@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

[@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.

[@Ashok2293]

Can you explain about average and averagex

[@AnalyticswithNags]

Soon will make video on this

[@venkatareddykummitha5863]

do a simple average calculations

[@AnalyticswithNags]

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