remove Null keyword in my entire column

[Anonymous]

Hi guy's

my column has numbers but some number is combined with null key values on how to remove  "Null"

like  null00101202 -->00101202 

regards,

Naveen

[Ashish_Mathur]

Hi,

In the Query Editor, you can right click on that column and select Replace values.  Type null and leave replace with empty.  Click on Replace All.

Hope this helps.

[Greg_Deckler · Accepted solution]

Well, in DAX you can use SUBSTITUTE:

Measure = SUBSTITUTE([Column],"null","")

In Power Query you can use Replace Values (right click the column)

[rajendraongole1]

In power query editor , we have transform tab, there you can pick split column option with by Nondigit to digit.

it will seperate both text and number.

or else you can do column from examples mention only dates.

I hope it will resolve your query.

Regards

Rajendra