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  Table 1 is your fact table and Table 2 is the Dimension Table, Right?

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

    Arioli_Chezhian I hope this helps you. Thank you.

    >Create Following Measures :
    Tbl1 =
    SUM ( 'Table Workspace'[Emp ID] )
    #################################
    Tbl2 =
    SUMX ( 'Table Flag', [Tbl1] )
    ################################
    Flag =
    IF ( [Tbl1] = [Tbl2], "Internal", "External" )



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

      Mahesh0016 
      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's avatar
        Mahesh0016
        Icon for Super User rankSuper User
        3 years ago

        Arioli_Chezhian okay, I will try and let you know one more thing is your employee ID length is same, right