How to remove Null Value without impacting the respective columns value?

[dipeshkumar30]

How to remove null values without impacting the associated columns value. if the null value is in the first column and others columns having value what we have to as we want to keep the others value.

Thanks in advance.

[BrianJ]

@dipeshkumar30,

1. Bring your data into Power Query:

2. Do Replace Value on nuil as follows:
   

   

3. Should be good to go:
   

   

• Brian

[dipeshkumar30]

thanks for the solution but one more question if i replace the null with blank would it create problem in data modelling or dax calculation. how power bi treat a blank cell ?

[BrianJ]

@dipeshkumar30,

I don’t think so. DAX uses blanks for both database nulls and for blank cells, so this should be fine.

The issue of nulls vs. blanks vs. empties is really confusing. If you want some additional background on this, here’s the best explanation I’ve found thus far:

DAX Fridays! #130: BLANK, ISBLANK

• Brian