Forum Discussion

Sebastian's avatar
Sebastian
Advocate 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])

HarrisMalik's avatar
HarrisMalik
Continued Contributor
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])

Shiva799's avatar
Shiva799
Frequent Visitor
8 years ago

Can this be used advanced editor? I want to check for null that i'll pass as parameters.

Thanks