Forum Discussion

kadingo's avatar
kadingo
Icon for Helper II rankHelper II
6 years ago
Solved

Check if column value is null or blank in DAX

I have the sample DAX query above. Is there away i can manipulate 'Target_FormResponse'[Area Used] such that if it is blank or empty, i return "No" otherwise if its not blank or empty i return "Yes".

 

In SSRS, i can do something like =IIF(Len(Fields!Form_Response.Value) > 0,"Yes","No") but i want to achieve this at the DAX query level.

 

On a different but related note, is there also away i can get only the time part (exclude the date) from an SSAS datetime column in the sample DAX query above?

 

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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,

     

2 Replies