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.
Hi everyone,
I need to calculate the median of a column but i'm accessing data trough Direct Query so the median function is inaccessible.
Is there any other way to calculate it?
Greetings
Hi.
In such case you need to calculate median in data source or do it in direct query, so it all depends on what data source you have.
T-SQL, for example, does not have median calculation function, AFAIK, so, you need to calculate it "manually".
Here is some explanation on how to to it and code example, maybe this helps:
https://codingsight.com/calculate-the-median-by-using-tsql/
Good luck 🙂
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 |
---|---|
14 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
7 | |
3 | |
3 |