Is-Null Function

 Top Previous Topic Next Topic  Print this topic

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

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

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

 

 

Is-Null

 

 

Note

•The above example is part of the Is-Null.dax document, located in the 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>