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.
I have a table in Power BI called Registration. The table has the following columns: timestamp, weekDay, Hour, events_failed. timestamp is the timestamp column, weekDay is the name of the day in the week like "Sunday", "Monday", "Tuesday", etc. Hour has the hour of the events and Hour goes from 0 to 23. 'events_failed' column is of data type integer and hold the number of events that has failed at that Hour. However, I can have many rows in a single Hour as there are other But here is the tricky part: I want to calculate percentile 25 of every group combination of weekDay and Hour. Example: percentile 25 for all 'Tuesday' at Hour 16, and following along the same way for all combinations of weekDay & Hour. In summary, I want to write a Measure in DAX that calculate the percentile 25 of 'events_failed' for all different combinations of groups of weekDay and Hour. I want the results in a new table called Percentiles with the following columns: weekDay, Hour, Percentiles_25, Percentiles_75.
Hello @Anonymous can you show a small sample of data and expected result
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |