Need help with DAX

[bhavinpatel_23]

I have email addresses in column10 of the query name report. I also have email addresses in column3 of the query name sheet1. I need to find uncommon email addresses between column10 and column3.

How do I write this?

Thank you guys as always.

[v-yuezhe-msft · Accepted solution]

@bhavinpatel_23,

Create the following calculated column in Report table.

DiffOfsheet1 = CALCULATE(COUNTROWS(sheet1),FILTER(sheet1,sheet1[Column3]=EARLIER(Report[Column10])))>0

Create the following calculated column in sheet1 table.
DiffOfreport = CALCULATE( COUNTROWS(Report), FILTER(Report, Report[Column10]= EARLIER( sheet1[Column3]) ) )> 0

Then create a new table using Dax below, and filter diff column to “False”.

Table = UNION(SELECTCOLUMNS(Report,"col",Report[Column10],"diff",Report[DiffOfsheet1]),SELECTCOLUMNS(sheet1,"col",sheet1[Column3],"diff",sheet1[DiffOfreport]))

If the above steps don’t help, please share sample data of your tables and post expected result here.

Regards,
Lydia

[bhavinpatel_23]

Thank you so much Lydia.

You are awesome. How do I learn more about DAX? where can I find different functions and meaning for those functions?

thanks again.