If the value from first column is missing in the second column the show value from column 1

Question

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&nbsp;Table 1 Serial number11121314151617&nbsp;Table 2 Serial number1112141516&nbsp;Result that I want.New Column1317&nbsp;&nbsp;

daniel29195 · Accepted Answer

TcT85&nbsp;sample data :&nbsp;&nbsp;output&nbsp;&nbsp;measureMeasure 13 = 
var ds = 
EXCEPT(
    values(tbl_1[col1]),values(tbl_2[col2])
)
return
CALCULATE(
    COUNTROWS(tbl_1),
    KEEPFILTERS(ds)
    )&nbsp;&nbsp;if you dont want to use a measure . you can simply refer to the below&nbsp; method :&nbsp;output&nbsp;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)&nbsp;&nbsp;&nbsp;&nbsp;let me know if it works for you .&nbsp;&nbsp;&nbsp;&nbsp;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! 🤠&nbsp;

Forum Discussion

If the value from first column is missing in the second column the show value from column 1

2 Replies

Related content

Inferring Missing Columns and Imputing Missing Data

missing data

Total value missing in calculated column

Generating Missing Data

missing data

Table 1 Serial number
11
12
13
14
15
16
17