Forum Discussion
Aggregate monthly data into quarterly average
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,
Hi Timmo1016
As you select the type of your date , in date format you can easily be able to show that column in date hierarchey of year-quarter. as you add this column in x-axis of bar chart, select date hierarchey and remove day and month. and dont forget to expant the visual .
you can add regions to the legend and for the y-axis you need to write a measure as follows:
measure _avg := var tbl=summarize ( your_table , date , #employees)
return averagex (tbl , #employee) /1000
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.