cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## 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
Continued Contributor

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

8 REPLIES 8
New Member

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

Resolver I

Use IsBlank() DAX function

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

Continued Contributor

@Sebastian

Try ISBLANK()

and to send data BLANK()

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.

Continued Contributor

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

Frequent Visitor

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.

Continued Contributor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors