need help to connvert sql query to dax

[sathyaramesh]

Hi,

      I have a sql query i need to implemet in dax.

select distinct id, name
from table1
where product= 'abc' and not exists (
select manufacturer, manu_name
from table2
where ltrim(rtrim(category)) <> 'AD' and column1= column1 and name= manu_name)

Thanks in advance

[v-yuta-msft]

@sathyaramesh ,

Does table1 and table2 have relationship with each other? Could you share some sample data?

Regards,

Jimmy Tao

[sathyaramesh]

Please check the below link i posted the sample data 

@v-yuta-msft 

https://community.powerbi.com/t5/Desktop/Need-help-to-implement-sql-query-to-dax/m-p/792418#M381460

Thanks