Appending two Queries using Union SelectColumn DAX accounting for Blank Dates

PHOTO EMBED

Thu Sep 02 2021 00:22:24 GMT+0000 (UTC)

Saved by @Darkleech #vba

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