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?