Create a calculated table, with annualized data, based on another table with monthly data.

[Syndicate_Admin]

Hello community,

I'm wanting to generate a new table, with annualized (averaged) data, based on the existing data in another table that shows me data month by month.

Example:

Table1 with monthly data.

Date	Item	Value
01/01/2020	Number 1	67
01/02/2020	Number 1	76
And so on until December 2020...
01/01/2021	Number 1	35
01/02/2021	Number 1	45
And so on until December 2021...
01/01/2022	Number 1	86
01/02/2022	Number 1	37
It would be fed month by month...

With that table I would like to create another one that shows me the average of each item per year and that the calculation is generated automatically as the months per year progress.

Table2, calculated, should look like this:

Date	Item	Annual Average Value
01/01/2020	Number 1	23
01/01/2021	Number 1	14
01/01/2022	Issue 1	3

Is there a way to do it? I was looking at the topic of calculated tables but I didn't find a way that would allow me to do what I need.

Thank you in advance for your help!

[v-chenwuz-msft]

Hi @Syndicate_Admin ,

You can use the default average measure via the "v" icon as the below picture.

Or please share example data and expect result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

That soundas doable. Please provide usable sample data and indicate expected outcome.