Check if column value is null or blank in DAX

Hi kadingo ,

We can use the following DAX to meet your requirement:

Table =
ADDCOLUMNS (
    FILTER (
        SUMMARIZE (
            NATURALLEFTOUTERJOIN ( 'Target_Category', 'Target_Form' ),
            'Target'[Area],
            'Target'[id],
            'Target'[Target date],
            'Target'[Target Time Rage],
            'Target_Category'[Origin],
            'Target_Category'[Sectotion],
            'Target'[Location],
            'Target_Category'[Ethencity],
            'Target_FormResponse'[Area Used],
            'Target'[Description]
        ),
        'Target'[id] = 111373268
    ),
    "Area Used Column", IF ( ISBLANK ( [Area Used] ), "No", "Yes" )
)

We can try to use the Time Value function to get the time part of a Date/Time column

Time = TimeValue([Date])

Best regards,