Hi, I’m trying to get the Median of a Time Column and coming up empty. I work in Health Care and we are trying to compute the Median Discharge Time for all Discharges that happen before 11am. I know how to use DAX to do the “Before 11” part, but how do I get the Median of a Date?
In Qlikview where I used to do most of my development, Dates are also numbers so it’s really easy to do. However in PBI, I get the error that the MEDIAN function can’t be done for dates.
Any help here would be appreciated!