Calculate Average of customer

[Sriku]

Need help.

1-Aug	1134
2-Aug	308
3-Aug	49932.62
4-Aug	51015.76
5-Aug	50672.14
6-Aug	57646.48
7-Aug	50303.9
8-Aug	504
9-Aug	1103
10-Aug	51190.1
11-Aug	51451.82
12-Aug	50465.14
13-Aug	58571.81
14-Aug	49450.36
15-Aug	407
16-Aug	860
17-Aug	50079.79

How to calculate average per month

[amitchandak · Accepted solution]

@Sriku , you need to have month year in table or date table, Try like

averageX(values(Table[Month-year]), sum(Table[value]))

or

averageX(values(Date[Month-year]), sum(Table[value]))

[Fowmy]

@Sriku 

What are the proper columns of your data, do you have a date table in the model?


Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn