Forum Discussion
Calculate Average Monthly Sales
Hi Experts
I would like to calculate avg.monthly sale based on my sales data. by Year by Month (if that makes sense).
See sample pbix. either as a calulcated column or measure route
sample file
Anonymous , I think you need Avg of Sum, Above month level.
Sum till month level and Avg above
averageX(Values('Date'[Month Year]), CALCUALTE(Sum('Table'[Sales])))
Discussed here how to use summarize for that
Hi, Anonymous
Please correct me if I wrongly understood your question.
If the below picture is what you are looking for, please check the link below that is the sample pbix file's link.
https://www.dropbox.com/s/54joh9bod275lml/2021%200330.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
5 Replies
- amitchandak
Super User
Anonymous , I think you need Avg of Sum, Above month level.
Sum till month level and Avg above
averageX(Values('Date'[Month Year]), CALCUALTE(Sum('Table'[Sales])))
Discussed here how to use summarize for that
- amitchandak
Anonymous , It is a measure.
- Jihwan_Kim
Hi, Anonymous
Please correct me if I wrongly understood your question.
If the below picture is what you are looking for, please check the link below that is the sample pbix file's link.
https://www.dropbox.com/s/54joh9bod275lml/2021%200330.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.