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 measur...
Need Help
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

colem246's avatar
colem246
Frequent Visitor
8 years ago

Here is an example of what it looks like. The last two columns are using the code you gave me. As you can see the columns at the top have missing data and still gives 12:00am in the last two columns. I would rather the last two columns be null.

 

Thanks

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Hi colem246,

     

    Could you change the postion of the Or condition like( replace the fields with the correct names):

     

    Or(isblank(), isblanck())

    I will make a try when I get a computer with Powerbi desktop.

    But let me know.

     

    Ninter

    • Interkoubess's avatar
      Interkoubess
      Solution Sage
      8 years ago

      Hi colem246,

       

      I tried the second approach proposed and it worked! 

      Please try it and let me know if you have any issues.

       

      IF(OR(ISBLANK('Activity First and Last'[First Arrival]),ISBLANK('Activity First and Last'[Activity Date])),BLANK(),'Activity First and Last'[Activity Date]-'Activity First and Last'[First Arrival])

      Ninter

      • colem246's avatar
        colem246
        Frequent Visitor
        8 years ago

        Hi Ninter,

         

        I am still getting an error.