Forum Discussion
Solved
Average 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!!
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!!
Not really as I wanted a way to force it to include all months present in the calendar ,
reagardless of whether that month had a value in the fact table.