Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello all.
I'm looking for some help on this DAX code:
Median Test 3 (next 3 months approved) =
VAR MedianValueDiscipline =
CALCULATE (
MEDIANX (
SUMMARIZE (
'Actual & Forecast Project Resources',
'Actual & Forecast Project Resources'[Work Week Ending Date],
'Actual & Forecast Project Resources'[Capsule Descriptions.Discipline],
"Median FTEs",
SUMX (
'Actual & Forecast Project Resources',
'Actual & Forecast Project Resources'[Consolidated FTEs]
)
),
[Median FTEs]
),
'Actual & Forecast Project Resources'[Final Consolidated Hours Type] = "Approved",
DATESINPERIOD (
'Actual & Forecast Project Resources'[Work Week Ending Date],
MAX ( 'Date'[EndOfThisWeek] ) - 1,
3,
MONTH
)
)
RETURN
MedianValueDiscipline
@DRA885 , did you manage to solve this? I am currently fasing the same problem.
Sorry thought I had the solution but this is still incorrect.
Obviously now still looking for a solution to this
solved with the following change to the Sum calculation of FTEs:
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |