Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

IF is not BLANK return the same value_Issue

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!

 

Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

    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'

2 Replies

  • AntonioM's avatar
    AntonioM
    Solution Sage
    4 years ago

    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'

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    4 years ago

    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])