Forum Discussion

nsadams87xx's avatar
nsadams87xx
Icon for Helper III rankHelper III
7 years ago
Solved

IF ISBLANK Return Blank

Hello,   I have a column I created that checks to see if there are blanks in my reference column and if there are, they should be replaced with the word Unknown, otherwise use the reference column ...
Need Help
Tips and Tricks
Tutorial Requests
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    Depending on your data source, they might not actually be BLANK().  They could be empty strings or a space or something. 

     

    I would fix this with Power Query instead of DAX.  In the home tab, click Edit Queries, and then find the Provider column.  Find a cell with a blank Provider, right click and select "Replace Values", replacing empty strings with "Unknown"

Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Depending on your data source, they might not actually be BLANK().  They could be empty strings or a space or something. 

 

I would fix this with Power Query instead of DAX.  In the home tab, click Edit Queries, and then find the Provider column.  Find a cell with a blank Provider, right click and select "Replace Values", replacing empty strings with "Unknown"

  • nsadams87xx's avatar
    nsadams87xx
    Icon for Helper III rankHelper III
    7 years ago

    Okay thanks.  I was thinking that too, this is a CVS file and honestly I really am not sure what is exactly in those cells.  I'll do what you suggested.