cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sebastian Member
Member

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 values for a periode it shows nothing. In this case I want to have 0.00 instead of nothing.

 

Have anyone an idea?

 

thanks

Sebastian

1 ACCEPTED SOLUTION

Accepted Solutions
HarrisMalik Established Member
Established Member

Re: function isnull

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

7 REPLIES 7
Bjoern Established Member
Established Member

Re: function isnull

@Sebastian

Try ISBLANK()

 

and to send data BLANK()

 

see also:

https://msdn.microsoft.com/en-us/library/ee634552.aspx

Sebastian Member
Member

Re: function isnull

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 Established Member
Established Member

Re: function isnull

@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 Member
Member

Re: function isnull

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 Established Member
Established Member

Re: function isnull

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

Rajiv1237 Regular Visitor
Regular Visitor

Re: function isnull

Use IsBlank() DAX function

 

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

Highlighted
Shiva799 Frequent Visitor
Frequent Visitor

Re: function isnull

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

Thanks