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" ) )
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter