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")
Arioli_ChezhianHelper II
Helper IIMahesh0016
I have a correction in the data. You have done SUM for Emp ID, just for example I gave Emp ID as number but in my case the EMP ID has alphabetics with numerics. (Example: abcd324).
In this case we cannot SUM the column right, as the datatype will stay as TEXT.
How to overcome this?
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_Chezhian
Mahesh0016
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.