Forum Discussion

pardeepd84's avatar
pardeepd84
Helper III
5 years ago
Solved

exclude null/blanks when subtracting

Hello,   I have grouped some data together which includes the following:   Company name Client ID Double up Double up min time Double Up max time     I am now trying to subtract the ...
Need Help
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    What if we try it like this?

    Column 1 =
ABS (
    IF (
        'Doubleup test (2)'[Double up Max Time] = ""
            || 'Doubleup test (2)'[Double up MIN Time] = "",
        BLANK (),
        'Doubleup test (2)'[Max] - 'Doubleup test (2)'[Min]
    )
)
jdbuchanan71's avatar
jdbuchanan71
Super User
5 years ago

pardeepd84 

Give this a try, the || is the OR in DAX.

Column 1 =
ABS (
    IF (
        ISBLANK ( 'Doubleup test (2)'[Double up Max Time] )
            || ISBLANK ( 'Doubleup test (2)'[Double up MIN Time] ),
        BLANK (),
        'Doubleup test (2)'[Max] - 'Doubleup test (2)'[Min]
    )
)