New Combined Column Table with selective and flexible scripts

PHOTO EMBED

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]   
	)
 )
content_copyCOPY