Forum Discussion

Vickram's avatar
Vickram
Helper III
5 years ago
Solved

Handling NULL values

I have seen many posts and solution re handling NULL values in Power BI but I could not find the solution I am seeking.  I have a column with variant data type: Number and NULL. So, this data cannot...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    The Data type of the column should be decimal and you should not feel the need to replace null with 0.  Your visuals should work perfectly.  Can you share the file's download link and show the exact problem.

Vickram's avatar
Vickram
Helper III
5 years ago

It did not work. Throws below error when tried to display the measure in a key card.

 

Vickram's avatar
Vickram
Helper III
5 years ago

Also, checking null values in IF condtion as below does not work

e.g. =IF([colA]=null, 0, [colA]). Can we check null using IS NULL like =IF([colA] IS NULL, 0, [colA]) just like in SQL.

Not sure how to check if the value is NULL in Power BI:

[colA]=null

or

[colA] is null

or

[colA] ="NULL"

or

[colA]="null"

or

[colA]=BLANK()