topic convert sql query to dax in DAX Commands and Tips

convert sql query to dax

phanisri19 — Thu, 16 Sep 2021 10:17:34 GMT

Hi Experts,
I have sql query which needs to be converted to dax
select count(id) as total from master
where id in
(select distinct pid from master
where type = 'yes')
and type = 'neutral'.

Thanks,
Phanisri

Re: convert sql query to dax

BeaBF — Thu, 16 Sep 2021 15:01:13 GMT

Can you provide any details?

Eg:
- do you need a calculated column, a measure, a table ...?
- table example
- result you expect

Re: convert sql query to dax

phanisri19 — Fri, 17 Sep 2021 01:32:20 GMT

BeaBF , I need either as a measure or column for the above query

Re: convert sql query to dax

BeaBF — Wed, 22 Sep 2021 09:18:47 GMT

Okay, but can you post an example of a table you run that query on? phanisri19