Forum Discussion

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...

Frequent Visitor

8 years ago

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

Solution Sage

8 years ago

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

Ninter

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
  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
    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