Forum Discussion
Calculating quartiles on a rolling/trailing average time value
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?
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.
2 Replies
please provide sample data in usable format, and show sample expected outome.
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.
