Monthly average

[Syndicate_Admin]

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

[Syndicate_Admin]

Thank you very much, having known that the measure was simple, with your formula if I throw the correct averages.

Thankful, greetings

[Ashish_Mathur · Accepted solution]

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.

[Syndicate_Admin]

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!

[Ashish_Mathur]

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.

[Syndicate_Admin]

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

[Ashish_Mathur]

Hi,

There is nothing i can understand there.  Someone who does will help you.

[Syndicate_Admin]

Thank you anyway. Question is it because of the language, or do you not understand what I am trying to say?

Thank you!