New Combined Column Table with selective and flexible scripts
Thu Aug 05 2021 04:50:14 GMT+0000 (Coordinated Universal Time)
Saved by @cnewnham
2 Tabke Nane= UNION ( SELECTCOLUMNS ( 'Beams - Corrective Actions - Incidents', "Workgroup", 'Beams - Corrective Actions - Incidents'[Site/Work Area], "Event ID", 'Beams - Corrective Actions - Incidents'[Parent ID], "Action ID",'Beams - Corrective Actions - Incidents'[Action ID], "Created Date",'Beams - Corrective Actions - Incidents'[Created Date], "Due Date",'Beams - Corrective Actions - Incidents'[Due Date], "Description",'Beams - Corrective Actions - Incidents'[Reference], "Action Status",'Beams - Corrective Actions - Incidents'[Status], "Report Type (revised)",'Beams - Corrective Actions - Incidents'[Event Report Type (revised)], "Event Severity (MRO)",'Beams - Corrective Actions - Incidents'[Event Severity (MRO)], "Event Actual Consequence",'Beams - Corrective Actions - Incidents'[Event Actual Consequence], "Source Type",'Beams - Corrective Actions - Incidents'[Source Type], "Serious Incident (PC1)",'Beams - Corrective Actions - Incidents'[Serious Incident (PC1)], "Serious Actual Consequence Incident",'Beams - Corrective Actions - Incidents'[Serious Actual Consequence Incident], "Completed Date ",'Beams - Corrective Actions - Incidents'[Completed Date], "Assigned To",'Beams - Corrective Actions - Incidents'[Assignee] ), SELECTCOLUMNS ( 'INX - Event - Actions - Incidents', "Workgroup", 'INX - Event - Actions - Incidents'[Workgroup], "Event ID", 'INX - Event - Actions - Incidents'[EventID], "Action ID",'INX - Event - Actions - Incidents'[Action Number], "Created Date",'INX - Event - Actions - Incidents'[Event Date], "Due Date",'INX - Event - Actions - Incidents'[Due Date], "Description",'INX - Event - Actions - Incidents'[Brief Description of Event], "Action Status",'INX - Event - Actions - Incidents'[Action Status], "Report Type (Revised)",'INX - Event - Actions - Incidents'[Event Report Type (revised)], "Event Severity (MRO)",'INX - Event - Actions - Incidents'[Event Severity (MRO)], "Event Actual Consequence",'INX - Event - Actions - Incidents'[Event Actual Consequence], "Source Type",'INX - Event - Actions - Incidents'[Source Type], "Serious Incident (PC1)",'INX - Event - Actions - Incidents'[Serious Incident (PC1)], "Serious Actual Consequence Incident",'INX - Event - Actions - Incidents'[Serious Actual Consequence Incident], "Completed Date",'INX - Event - Actions - Incidents'[Completion Date], "Assigned To",'INX - Event - Actions - Incidents'[Responsibility] ) )
Comments