Forum Discussion
Monthly average
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.
Thanks for responding. What I'm looking for is this:
In which I have created 2 measures (e.g. days Monday to Friday)
1 Business Days of the month: applies to closed months prior to the current one (current month April: 22 days)
2 Elapsed Business Days of the month: applies to unfinished month, i.e. current month (as of today 04/26: 20 days)
What I need is a daily average: divide by the 1 Business Days of the Month in previous months, already closed
y
divide by the 2 Past Business Hours of the Month in the current month, sales, profits, volumes, etc.
I hope I've been clear.
- Monday to Friday
Hi,
There is nothing i can understand there. Someone who does will help you.
Thank you anyway. Question is it because of the language, or do you not understand what I am trying to say?
Thank you!