How to calculate median in Direct Query

d0rthv0der — Mon, 28 Oct 2019 15:57:47 GMT

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

Re: How to calculate median in Direct Query

andris — Wed, 30 Oct 2019 09:21:51 GMT

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:

Good luck 🙂