Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
please provide sample data in usable format, and show sample expected outome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |