Forum Discussion
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...
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])
My solution will be to add +0 to your calculation and the zeros will show. You can then reformat it to decimal.