Is-Null function tests if the input value is NULL.

If the input value is NULL, the function returns a "true" value, otherwise it returns a "false" value.

In the following sample, the is-null function returns "true" if date-modified is NULL, otherwise it returns "false".

 

 

 

 

Note. This sample can be found in Is-Null.dax in Samples\Job Samples folder.

 

OUTPUT:

 

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<ns:root xmlns:ns="http://www.tempuri.org/XML">

       <ns:hist date-modified="2009-07-01T00:00:00Z" is-null="false"/>

       <ns:hist date-modified="2009-07-22T00:00:00Z" is-null="false"/>

       <ns:hist date-modified="2009-07-16T00:00:00Z" is-null="false"/>

       <ns:hist date-modified="2009-07-22T00:00:00Z" is-null="false"/>

       <ns:hist date-modified="2009-07-16T00:00:00Z" is-null="false"/>

       <ns:hist date-modified="2009-07-17T00:00:00Z" is-null="false"/>

       <ns:hist date-modified="2009-08-27T00:00:00Z" is-null="false"/>

</ns:root>