Forum Discussion
Solved
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 PowerQuer...
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.
V-lianl-msft
Community Support
Community SupportHi 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.