Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |