Forum Discussion

ToddMate's avatar
ToddMate
Helper II
7 years ago
Solved

Help: Where date is null.

Hi Guys,   Hopefully a quick one, i know the measure below doesn't work but for the life of me i can't work out how to say "where the connect date is null" ... Can anyone help out here please.   ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, ToddMate 

    Just adjust your formula as below:

    Connects = CALCULATE(SUM('X_Detail'[Count]),FILTER('X_Detail','X_Detail'[Product] in {"A","B"}),FILTER('X_Detail','X_Detail'[Connect Date] =BLANK() ))

    or use ISBLANK Funtion 

    Connects = CALCULATE(SUM('X_Detail'[Count]),FILTER('X_Detail','X_Detail'[Product] in {"A","B"}),FILTER('X_Detail',ISBLANK('X_Detail'[Connect Date] ) ))

    https://docs.microsoft.com/en-us/dax/isblank-function-dax

     

    is null couldn't be used in DAX.

     

    Best Regards,

    Lin

ToddMate's avatar
ToddMate
Helper II
7 years ago

Hi TomMartens 

 

Yes that is correct, x_detail contains rows, one of the columns in this table is the connect date which can either contain a date or be null.

 

I can't upload the .pbix at this stage i'm sorry but i have attached a screenshot of the table field lists.

 

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, ToddMate 

Just adjust your formula as below:

Connects = CALCULATE(SUM('X_Detail'[Count]),FILTER('X_Detail','X_Detail'[Product] in {"A","B"}),FILTER('X_Detail','X_Detail'[Connect Date] =BLANK() ))

or use ISBLANK Funtion 

Connects = CALCULATE(SUM('X_Detail'[Count]),FILTER('X_Detail','X_Detail'[Product] in {"A","B"}),FILTER('X_Detail',ISBLANK('X_Detail'[Connect Date] ) ))

https://docs.microsoft.com/en-us/dax/isblank-function-dax

 

is null couldn't be used in DAX.

 

Best Regards,

Lin