Calculating quartiles on a rolling/trailing average time value

[MostlyLost]

My data is as follows:

DataDate (date)

ProcedureType (text)

Location  (text)

ProcedureTimeMinutes (WholeNumber)

ProcedureDuration (Date/Time) <-This is calculated as a duration type in PowerQuery, but I cannot figure a way to keep that in PowerBI

Physician (text)

I am trying to look back 7 days (but the time range may change), and calculate quartile break points for procedure times. The visualization will need to be able to be sliced by ProcedureType, Location, and Physician.

How do I go about calculating the quartiles, and be able to display times/durations that are greater than 24 hours?

[V-lianl-msft · Accepted solution]

Hi @MostlyLost ,

You could refer to this:

https://sqldusty.com/2018/08/31/calculating-quartiles-with-dax-and-power-bi/ 

If the problem persists,could you share the sample data and the result you expected?

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

please provide sample data in usable format, and show sample expected outome.