Forum Discussion
Solved
Aggregate monthly data into quarterly average
Hello, I am pretty new to powerBI. I am attempting to report on quarterly headcount data. My current table (below) is broken out monthly by regions (I am only able to add Region A here, but there...
Hi Timmo1016 ,
It's simple to produce the required output. First, create a calendar table and establish a relationship with your headcount fact table. Then, perform the average calculation as shown below:
I have attached an example pbix file for your reference.
Best regards,
DataNinja777
Super User
Super UserHi Timmo1016 ,
It's simple to produce the required output. First, create a calendar table and establish a relationship with your headcount fact table. Then, perform the average calculation as shown below:
I have attached an example pbix file for your reference.
Best regards,