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?
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
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 .
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.
Excellent....to resolve smoothly without writing complete dax instead using quick measure
Yes, you are right
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?
You can’t I think.
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
In table properties uncheck total column
@@AnalyticswithNags Thanks for the response and let me check this option
Your measure is awesome easily understable ....Sir
Thanks keep learning share this channel with friends and colleagues
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 .
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.
yes
Calculate (average (sale amount), datesinperiod(date column, date,-3, month)
Check playlists of this channel and explore topics on the similar line requested by you.
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.
Exclude those months in dax
@@AnalyticswithNagsTHANKS FOR THE REPLY, CAN U GIVE A HINT HOWTO DO IT.
l am getting values in rolling average similar to month sales, in that case how it should be over come
Didn't understand your question.
Can you elaborate
Is it possible for 3 days moving average?
please help me
Yeah we can do it , just change the parameters
Can you explain about average and averagex
Soon will make video on this
do a simple average calculations
Will do soon.
Meanwhile
You can try by changing the aggregation from sum to average
Thanks
thanks , keep learning