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,

 

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.

    • 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