Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Sebastian
Advocate II
Advocate II

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

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

View solution in original post

8 REPLIES 8
Akinwande_Ab
New Member

My solution will be to add +0 to your calculation and the zeros will show. You can then reformat it to decimal. 

Rajiv1237
Resolver I
Resolver I

Use IsBlank() DAX function

 

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

Bjoern
Continued Contributor
Continued Contributor

@Sebastian

Try ISBLANK()

 

and to send data BLANK()

 

see also:

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

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.

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

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

Thanks

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.

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.