Forum Discussion

Arioli_Chezhian's avatar
Arioli_Chezhian
Icon for Helper II rankHelper II
3 years ago
Solved

Create 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"...
"Need Help"
General Comments
tips & tricks
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    Arioli_Chezhian  Please Try This one.

    Flag =
    IF (
        SELECTEDVALUE ( 'Table 1'[Emp ID] ) = MAX ( 'Table 2'[Emp ID] ),
        "Internal",
        "External"
    )

     

     

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

Arioli_Chezhian  Please Try This one.

Flag =
IF (
    SELECTEDVALUE ( 'Table 1'[Emp ID] ) = MAX ( 'Table 2'[Emp ID] ),
    "Internal",
    "External"
)