Notifications
Clear all
Power Query
4
Posts
3
Users
0
Reactions
183
Views
Topic starter
Hi I'm a Newbie here, just learning Power Query.
I have a couple of Columns, which when I converted them to Currency Columns replaced all the blank fields with null.
I'm trying to replace the Null with "", but I'm getting an error telling me to replace it with a number value. I know I could use 0, but I really want these values to be blank. Can someone help please.
Many thanks.
Posted : 20/03/2025 6:05 am
Hi Colin, Data type of your columns is Currency, so it has to be either 0 or null. If you want it to be "", you'd have to change data type to Text - as far as I know.
This post was modified 1 month ago by Blanka Blair
Posted : 20/03/2025 6:33 am
Topic starter
OK many thanks
Posted : 20/03/2025 6:35 am
Change it to currency after you replace the nulls.
Posted : 21/03/2025 8:04 am
