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,

 

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.

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Hi colem246,

     

    Are you creating this calculation as a column and not a measure?

     

     I created as a calculated column. Let me know if it is the case.

     

    Ninter

  • colem246's avatar
    colem246
    Frequent Visitor
    8 years ago

    I am using measure for this because I am ultimately going to be calculating the average time of the first, last, etc.....

     

    Using a calculated column wouldnt allow for this type manipulation will it? Also, I only want the time stamp to show, not date and time since date is already populated in the activity date column.

     

    Thanks

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Then use the formula with or with a combination of Datediff.

     

    It should work...

     

    Ninter.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi colem246,

    Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

    Best Regards,
    Angelia