Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Instert Row based on Condition

I have two tables that are tied by COID.  I have a list of Vacant posistions per COID and i need to add this row to the table that has the employees.   Table 1 Vacant Posistion: Vacant   COID...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous can you provide sample data and expected output.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    parry2k the second table below and highlighted green is what i need to add into table 1

     
    Division COID Facility Employee Name Job Description Yearly Pay
    SC DIVISION 12345 Harbor Town Tom Thomas Supv Fac Mgmt/Safety/Sec $57,138
    SC DIVISION 12345 Harbor Town Brad Sellers Coordinator Support Svcs (CW) $52,000
    SC DIVISION 12345 Harbor Town Morgan Evans Engineering Craft Worker $44,554
    SC DIVISION 12345 Harbor Town Sam Smith Engineering Tech Specialist $44,138
    SC DIVISION 12345 Harbor Town Vacant Dir Fac Mgmt/Safety/Sec xxxxxx
               
    Vacant COID Facility Change Vacancy Date DFM Start Date
    Vacant 12345 Harbor Town Left HCA 6/14/2019 12/20/18
    Vacant 54635 Tri County Left HCA 4/9/2018 9/17/18
    Vacant 22448 Macon Left HCA 4/20/2020 7/2/18
    Vacant 34854 Table Top Left HCA 3/20/2020  
    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      Anonymous how the table 1 columns are mapped to table 2, you can use UNION DAX function or you can append queries in Power Query

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        parry2k they are mapped using COID.  I feel that i am going to need to do a Power Query but not sure the best way to go about it.