Forum Discussion
Arioli_Chezhian
Helper II
Helper IICreate calculated column in Live connection
Hello All, I have 2 tables, Table 1 is live connection(Using existing dataset) and Table 2 is import file. The Employee ID present in import file should be shown as "Flag - Internal"...
Arioli_Chezhian Please Try This one.
Flag =IF (SELECTEDVALUE ( 'Table 1'[Emp ID] ) = MAX ( 'Table 2'[Emp ID] ),"Internal","External")
Mahesh0016
Super User
Super UserArioli_Chezhian okay, I will try and let you know one more thing is your employee ID length is same, right
Arioli_ChezhianHelper II
Helper IIMahesh0016
Yes it's consists of 4 alphabetics continue with 3 numerics (abcd324).
- Mahesh0016
Arioli_Chezhian it's Done Please Check my Solution. Thank You.
- Arioli_Chezhian
Mahesh0016 - I tried but when I drag and drop this measure, the visual keeps on loading.
- Mahesh0016
Arioli_Chezhian are you plot columns from the fact table or Dim in visual?