Forum Discussion
Monthly average
Good afternoon community. I have reviewed several posts related to the issue of calculating the Monthly Average, I have implemented several of the formulas they have given, but it does not give me the correct results. I have this information:
of those monthly totals, I need to take out the average sale for each month. I do it in a static way, verify it by doing the calculation on foot, and the result that throws me is correct, but it is not the idea of making it static, because if I make multiple selection of two or more months, it must give me the correct result and it does not.
In advance thank you for your help.
Best regards
Ensure you have a Calendar table. Create a slicer from the Year column of the Calendar Table and select 2022. To your visual, drag Month name from the Calendar Table. Write this measure
=divide([Total venta mensual],countrows(Calendar))
Hope this helps.
7 Replies
Ensure you have a Calendar table. Create a slicer from the Year column of the Calendar Table and select 2022. To your visual, drag Month name from the Calendar Table. Write this measure
=divide([Total venta mensual],countrows(Calendar))
Hope this helps.
Thanks for the reply, but in case you want to average daily, for example Sales $, of each month, but with business days from Monday to Friday, Monday to Saturday and Monday to Sunday, how could I do it?
For the current month and closed months.
Thank you!
Hi,
Share some data to work with, explain the question and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Thank you very much, having known that the measure was simple, with your formula if I throw the correct averages.
Thankful, greetings
