Creating a Calculated Table using date from an existing Table

^{Hi nfuids ,}

^{You can also use the following writing.}

Calculate table =
FILTER (
    UNION (
        SELECTCOLUMNS (
            'Table',
            "Title", [Title],
            "StartDate", [StartDateDev],
            "EndDate", [EndDateDev],
            "Category", "Dev"
        ),
        SELECTCOLUMNS (
            'Table',
            "Title", [Title],
            "StartDate", [StartDateUAT],
            "EndDate", [EndDateUAT],
            "Category", "UAT"
        ),
        SELECTCOLUMNS (
            'Table',
            "Title", [Title],
            "StartDate", [StartDateINTG],
            "EndDate", [EndDateINGT],
            "Category", "INGT"
        )
    ),
    [StartDate] <> BLANK ()
        && [EndDate] <> BLANK ()
)

^{The only difference between the two writing is that SUMMARIZE will deduplicate the data and SELECTCOLUMNS will not, and if this has no effect on your data, then there is no difference.}

SELECTCOLUMNS - DAX Guide

^{Best Regards,}

^{Gallen Luo}