Instert Row based on Condition

Question

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

Facility

Change

Vacancy Date

DFM Start Date

Table 2 Employees:

Division

COID

Facility

Employee Name

Job Desc

Pay

parry2k · Answer

Anonymous&nbsp;can you provide sample data and expected output.

anonymous · Answer

parry2k&nbsp;the second table below and highlighted green is what i need to add into table 1&nbsp;Division&nbsp;COID&nbsp;Facility&nbsp;Employee Name&nbsp;Job Description&nbsp;Yearly PaySC DIVISION&nbsp;12345&nbsp;Harbor Town&nbsp;Tom Thomas&nbsp;Supv Fac Mgmt/Safety/Sec&nbsp;$57,138SC DIVISION&nbsp;12345&nbsp;Harbor Town&nbsp;Brad Sellers&nbsp;Coordinator Support Svcs (CW)&nbsp;$52,000SC DIVISION&nbsp;12345&nbsp;Harbor Town&nbsp;Morgan Evans&nbsp;Engineering Craft Worker&nbsp;$44,554SC DIVISION&nbsp;12345&nbsp;Harbor Town&nbsp;Sam Smith&nbsp;Engineering Tech Specialist&nbsp;$44,138SC DIVISION&nbsp;12345&nbsp;Harbor Town&nbsp;Vacant&nbsp;Dir Fac Mgmt/Safety/Sec&nbsp;xxxxxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Vacant&nbsp;COID&nbsp;Facility&nbsp;Change&nbsp;Vacancy Date&nbsp;DFM Start DateVacant&nbsp;12345&nbsp;Harbor Town&nbsp;Left HCA&nbsp;6/14/2019&nbsp;12/20/18Vacant&nbsp;54635&nbsp;Tri County&nbsp;Left HCA&nbsp;4/9/2018&nbsp;9/17/18Vacant&nbsp;22448&nbsp;Macon&nbsp;Left HCA&nbsp;4/20/2020&nbsp;7/2/18Vacant&nbsp;34854&nbsp;Table Top&nbsp;Left HCA&nbsp;3/20/2020&nbsp;&nbsp;

parry2k · Answer

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

anonymous · Answer

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

edhans · Answer

What is COID? To add records from one table to another, use Table.Combine(), which is the APPEND menu item on the Home ribbon.
&nbsp;
Otherwise, I'll need a few more specifics about the goal and what you are using.

Forum Discussion

Instert Row based on Condition

7 Replies

Related content

Conditional formatting based on rules

Conditional formatting based on multiple conditions

Conditional Formatting Based on Measure

Column Formula : Based on condition

delete rows based on conditions

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