Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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
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
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |