Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
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
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?
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?
User | Count |
---|---|
102 | |
84 | |
77 | |
70 | |
67 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |