Forum Discussion
TcT85
Helper III
2 years agoIf the value from first column is missing in the second column the show value from column 1
Hi, Is this possible? If the value from first column is missing in the second column the show value from column 1. I have 2 tables Table 1 Serial number 11 12 13 14 15 16 ...
- 2 years ago
sample data :
output
measure
Measure 13 = var ds = EXCEPT( values(tbl_1[col1]),values(tbl_2[col2]) ) return CALCULATE( COUNTROWS(tbl_1), KEEPFILTERS(ds) )if you dont want to use a measure . you can simply refer to the below method :
output
Measure 13 = var ds = EXCEPT( values(tbl_1[col1]),values(tbl_2[col2]) ) var c = CALCULATE( COUNTROWS(tbl_1), KEEPFILTERS(ds) ) return if(ISBLANK(c), 0,1)let me know if it works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Ritaf1983
Super User
2 years agoHi TcT85
You can achieve the goal with EXCEPT function .
Please refer to the linked discussion:
https://community.fabric.microsoft.com/t5/Desktop/List-rows-that-are-missing-in-another-table/m-p/272307
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.