Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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))
Dear
I tried the first option and I get the following error. Have I written something wrong?
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |