Need help with DAX

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. Ho...

Need Help

Anonymous
8 years ago
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

Anonymous

Not applicable

8 years ago

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
Frequent Visitor
8 years ago
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.

Forum Discussion

Need help with DAX