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 am bringing data from Table 1, which contains all the emp ID. Even in Table 1 it has unique records, no duplicates.
Mahesh0016
Super User
Super UserArioli_Chezhian Please can you Elobrate Table 1 and Table 2 Relationships.
For E.g One To Many, One to One
- Arioli_Chezhian
Mahesh0016 - One to One
- Mahesh0016
Arioli_Chezhian Please Try This one.
Flag =IF (SELECTEDVALUE ( 'Table 1'[Emp ID] ) = MAX ( 'Table 2'[Emp ID] ),"Internal","External")