Forum Discussion
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.
How do I write this?
Thank you guys as always.
Create the following calculated column in Report table.
DiffOfsheet1 = CALCULATE(COUNTROWS(sheet1),FILTER(sheet1,sheet1[Column3]=EARLIER(Report[Column10])))>0Create the following calculated column in sheet1 table.
DiffOfreport = CALCULATE( COUNTROWS(Report), FILTER(Report, Report[Column10]= EARLIER( sheet1[Column3]) ) )> 0Then 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
2 Replies
Create the following calculated column in Report table.
DiffOfsheet1 = CALCULATE(COUNTROWS(sheet1),FILTER(sheet1,sheet1[Column3]=EARLIER(Report[Column10])))>0Create the following calculated column in sheet1 table.
DiffOfreport = CALCULATE( COUNTROWS(Report), FILTER(Report, Report[Column10]= EARLIER( sheet1[Column3]) ) )> 0Then 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,
LydiaThank 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.
