Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |