Average % overall monthly and by workplace

[Syndicate_Admin]

Hello

My company is changing the format of reporting to Power BI and the average of the % compliance of the Holding per month and per work center must be presented in a dynamic way.

The information begins in September 2021 to date. But for the exercise, consider June 2022. My table is as follows:

the idea is to represent it in this way and at the same time by work center.

I have tried with accumulated, average mobile, among other ways, without giving me the same results. That is why I turn to you, for guidance.

Of course, thanking you for your help,

Carolina.

[amitchandak]

@Syndicate_Admin , Nor vet clear, You need like

3 Month Avg = CALCULATE(AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Value)))
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))

or

CALCULATE(AverageX(Values('Table'[work center]),calculate(Sum('Table'[Value)))
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-13,MONTH))

[Syndicate_Admin]

Dear

I tried the first option and I get the following error. Have I written something wrong?