Log In
Register
Home
MEDIANIFS Function
James Heaney Regalado
Member
Members
Dashboards
Power Query
Power Pivot
Pivot Tables Quick Start
Dashboards
Power Query
Power Pivot
Pivot Tables Quick Start
Forum Posts: 12
Member Since:
August 11, 2023
August 11, 2023
Offline1
August 12, 2023 - 5:44 am
I was about to ask the question, but worked out a solution first so thought I would share. For MEDIAN, there isn’t an if/ifs equivalent. You can put an IF inside the MEDIAN function, =MEDIAN(IF(criteria,array)) but this workaround fails if there’s an even number of entries. A workaround I found online was putting the data into a pívot table, adding it to the data model, and using DAX function instead.
However, I’ve found a better workaround by using FILTER. =MEDIAN(FILTER(array,criteria))
Is there any other functions that don’t have an ‘if’ equivalent that this might work for?
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 925
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 345
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Karen Brown
Arieta Salihu
Garry Miller
Shuonan Zhou
Kelly Woolum
Belinda White
Barbara White
Ross McCarty
Lisa Donaldson
Hiroyuki Murai
Forum Stats:
Groups: 3
Forums: 25
Topics: 7088
Posts: 31068
Member Stats:
Guest Posters: 49
Members: 34510
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —