Forum Discussion

colem246's avatar
colem246
Frequent Visitor
8 years ago

Exclude Null Data from Subtraction

Hello,

 

Im subtracting two columns that both include the date. Some of the cells are empty because no dates are available for the information.. How can I exclude the null information in the measure?

 

What I have so far is:

 

FirstTime = 'Activity '[First Time]-'Activity [Activity Date]

 

The result I get for the null values is just "12:00:00AM" but I would rather not have the data show.

 

Thanks

Need Help

11 Replies

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Hi colem246,

     

     

    Please try something with an if like this:

     

    if(isblank( or('Activity '[First Time]), 'Activity [Activity Date])),blank(), Activity '[First Time])-'Activity [Activity Date])

    Let us know if it does not work...

     

    Ninter

    • colem246's avatar
      colem246
      Frequent Visitor
      8 years ago

      This is still giving me 12:00am even when the 'Activity '[First Time] is blank.

       

       

      • Interkoubess's avatar
        Interkoubess
        Solution Sage
        8 years ago

        hi colem246,

         

        Please give a sample data with your expected result and then I can try another approach.

         

        Ninter