Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |