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.
Dear Community
I'm created a MEDIAN measure for salesPrice.
As you can see on my screenshot, the blue line is the result I currently get.
But what I like to get is the Median based on the selected date range.
That would be 53.67 in my example, because this is the middle value (median) of this three numbers.
I tried the followning meaure but I don't work as expected.
Test_Medain =
Var Var_LastDate = Max('Time'[DateKey])
Var Var_FirstDate = Min('Time'[DateKey])
Var x =
CALCULATE(
MEDIAN(OrderLine[SalesPriceEUR])
,Filter(
ALL('Time')
,AND('Time'[DateKey] >= Var_FirstDate ,
'Time'[DateKey] <= Var_LastDate
)
)
)
Return (x)
Any plans how I must modify my query?
Thx
Solved! Go to Solution.
Please adjust the measure MyMedian to your needs. File attached.
User | Count |
---|---|
25 | |
11 | |
8 | |
7 | |
6 |
User | Count |
---|---|
24 | |
13 | |
12 | |
10 | |
6 |