Forum Discussion
Dicken
Post Prodigy
Post ProdigyAverage granularity
Hi, i have a question iif i have a fact tabel, over a copupe of years, but not all years have all months , so example may start Feb to Oct. if i want an average total / 12 if so I...
Hi Dicken ,
May I ask if the provided solution helped in resolving the issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you!!
Ashish_Excel
Solution Supplier
Solution SupplierHi,
Since you do not have data for all the months shown in the Calendar table, the average will only be for the months for which you have data in the Fact table. You should just use the first 2 measures. Also, simplify the first measure to
=sum(Table1[units])