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?