Forum Discussion

Sebastian's avatar
Sebastian
Icon for Advocate III rankAdvocate III
10 years ago
Solved

function isnull

Hi all,   exist a function in power bi which works like the function "isnull" in t-sql?   I have a measure which sum a value over a periode and it shows the result in a table. If there aren't any...
Need Help
  • HarrisMalik's avatar
    HarrisMalik
    10 years ago

    Sebastian can you share your expression? because isblank() returns you a boolean so it can be used with conditional expressions. If you want to to return blank value you can use something like

     

    IF( ISBLANK(TABLE[MEASURE]), BLANK(),TABLE[MEASURE])

     

    OR

     

    IF( ISBLANK(TABLE[MEASURE]), 0,TABLE[MEASURE])

Rajiv1237's avatar
Rajiv1237
Icon for Resolver I rankResolver I
8 years ago

Use IsBlank() DAX function

 

TestNullData = IF(ISBLANK(ExchangeRate[ValidTo]), 1, 0)