79382987

Date: 2025-01-24 01:06:11
Score: 0.5
Natty:
Report link

The best approach for this problem is as follows:

Click Group By from the Transform Banner:

enter image description here

Group By: pick the columns that you need to keep their name, pick the "Median" operation (important!) and any other measures that you need (I, for example, needed "Count"):

enter image description here

Now that I have the "Median", AKA List.Median, I can easily change it to List.Percentile ([Value], 0.9). Right Click "Advanced Editor" and change the code accordingly:

enter image description here

And change the code in the "Grouped Rows" section from:

{"Per90th", each List.Median([Value]), type nullable number}}
To:
{"Per90th", each List.Percentile([Value],0.9), type nullable number}}
Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Hila DG