Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am using GROUPBY in several queries and are running into an issue.
According to Microsoft's documentation GROUPBY supports the aggregation (X) functions for grouping data.
But they also write that CURRENTGROUP on which it depends only supports a subset of the 'X' functions.
More specifically I am missing 'MEDIANX' which does not work with CURRENTGROUP and therefore not with GROUPBY.
I read some questions, also on this forum about this issue where people see it as a bug.
My question(s) are:
- Is it indeed a bug that MEDIANX is not supported, or is there some logic behind it?
- Is there a clever workaround (maybe with SUMMARIZE?) which produces the same results as GROUPBY, but with support for MEDIANX?
Solved! Go to Solution.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |