Forum Discussion
Average based on Tot Comp each month
Hi all,
I need some assistance.
I wanted to calculate the average for each month. The calculation that I want is,
Avg = Sum of Sales in each month / Tot No. of Companies in each month
Is there a DAX measure that I can use to calculate it? Appreciate if someone can help. Tq in advance!
Hi,
I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
2 Replies
- Jihwan_Kim
Super User
Hi,
I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.