IF is not BLANK return the same value_Issue

[Anonymous]

Dear All,

I have the table below in which i created a column for new clients. If the cell has sme value it should be copied, and in case it's empty "0" should be added.

But my measure is not working, what's my mistake?

New customers (if error) = IF('New Customers'[New Clients]= BLANK(),0)FALSE'New Customers'[New Clients])

Thanks!

[AllisonKennedy]

@Anonymous  You have an extra 0)FALSE : 

your measure:

New customers (if error) = IF('New Customers'[New Clients]= BLANK(),0)FALSE'New Customers'[New Clients])

should be: 

New customers (if error) = IF('New Customers'[New Clients]= BLANK(), 'New Customers'[New Clients])

[AntonioM · Accepted solution]

I think your column should be

New customers (if error) = IF('New Customers'[New Clients]= BLANK(),0,'New Customers'[New Clients])

If you're just replacing blank with 0 you could do also this is power query using 'replace values'