Need help to implement sql query to dax

[sathyaramesh]

I have a sql query i need to convert into dax

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

Thanks in Advance

[v-chuncz-msft · Accepted solution]

@sathyaramesh 

You may add a calculated column.

Column =
Table1[product] = "abc"
    && ISEMPTY (
        FILTER (
            Table2,
            Table2[category ] <> "AD"
                && Table2[column1] = Table1[column1]
                && Table2[manu_name] = Table1[name]
        )
    )

https://www.sqlbi.com/?s=SQL+to+DAX

[Greg_Deckler]

Can you provide some sample data and expected output from that data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Do you want this to be a calculated table or are you going for a table visual that implements the pattern that you indicate?

[sathyaramesh]

Hi  @Greg_Deckler 

 Thannk you so much for the replay.

     Here is the sample execl file for both Table1 and Table 2.

column1= column1 and name= manu_name both contain a mamy to many relationhip.Sample data

 I am going for a table visual that implements the pattern.

Thanks.

---

@Greg_Deckler wrote:

Can you provide some sample data and expected output from that data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Do you want this to be a calculated table or are you going for a table visual that implements the pattern that you indicate?

---