How to calculate median in Direct Query

[d0rthv0der]

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

[andris]

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 🙂