3 Actions - Combined - Audits = UNION (
SELECTCOLUMNS (
'VenSafe - Actions',
"ID", 'VenSafe - Actions'[ID],
"Action", 'VenSafe - Actions'[Action],
"Due Date", 'VenSafe - Actions'[Due Date],
"DaysUntilDue", 'VenSafe - Actions'[DaysUntilDue],
"OwnerName", 'VenSafe - Actions'[OwnerName],
"ModuleId", 'VenSafe - Actions'[ModuleId],
"ModulePrefix", 'VenSafe - Actions'[ModulePrefix],
"Type", 'VenSafe - Actions'[Type],
"ActionID", 'VenSafe - Actions'[ActionID],
"Status", 'VenSafe - Actions'[Status],
"CreatedByName", 'VenSafe - Actions'[CreatedByName],
"CreatedDate", 'VenSafe - Actions'[CreatedDate],
"UpdatedByName", 'VenSafe - Actions'[UpdatedByName],
"Completed", 'VenSafe - Actions'[Completed],
"CompletedByName", 'VenSafe - Actions'[CompletedByName],
"FullDescription", 'VenSafe - Actions'[FullDescription],
"UpdatedDate", 'VenSafe - Actions'[UpdatedDate],
"CompletedDate", 'VenSafe - Actions'[CompletedDate],
"Source","VenSafe"
),
SELECTCOLUMNS (
'BEAMS - All Actions',
"ID", 'BEAMS - All Actions'[ID],
"Action", 'BEAMS - All Actions'[Action],
"Due Date", 'BEAMS - All Actions'[Date Due],
"DaysUntilDue", "",
"OwnerName", 'BEAMS - All Actions'[Owner],
"ModuleId", "",
"ModulePrefix", "",
"Type", 'BEAMS - All Actions'[Topic],
"ActionID", 'BEAMS - All Actions'[Action ID],
"Status", 'BEAMS - All Actions'[Status],
"CreatedByName", 'BEAMS - All Actions'[Assigned by],
"CreatedDate", BLANK(),
"UpdatedByName", "",
"Completed", "",
"CompletedByName", "",
"FullDescription", 'BEAMS - All Actions'[Description],
"UpdatedDate", "",
"CompletedDate", 'BEAMS - All Actions'[Date Completed],
"Source","Beams"
)
)
Comments