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

Sebastian's avatar
Sebastian
Advocate III
10 years ago

I tried this function but as i used isblanc() the measure showed 0.00 like i want it but deleted all other values from other fields in the same row.

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

  • Sebastian's avatar
    Sebastian
    Advocate III
    10 years ago

    Ah ok,

     

    it was as stupid mistake by myself.

     

    I use if(isblank(table[measure]='true';0.00;table[measure]

     

    Sorry guys.

     

    Thanks a lot.

    • HarrisMalik's avatar
      HarrisMalik
      Continued Contributor
      10 years ago

      Sebastian Good that it helps you. Do not forget to mark it as answered in order to help others.

  • 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