Replace the blank value with TEXT

[Anonymous]

I have to replace a blank value with a text.

In below visuals, Need to replace the blank value with any text say "Unknown". first column is coming from one table, and 2nd and 3rd columns are coming from another table. Both the tables are connected with a common key. I understand that, I have to create a measure to achieve this, but while writing the measure I am getting difficulty.

Replace with Unknown =

VAR _comp_code = MAX('REP EMPLOYEE_DAILY'[COMP_CD_TXT])

RETURN

IF(ISBLANK(_comp_code), "Unknown", _comp_code)

In the above measure calculation, instead of MAX function, which function can I use so that it can take all the values?

Thanks.

[Anonymous]

Try IF ( TEXT, TEXT1, 0 )

or

Try IF ( ISBLANK(TEXT), TEXT1, 0 )

I hope this helps

[Anonymous]

@Anonymous , this didn't help. The blank value is coming while combining both the tables. There is no blank value in the single table. I wanted to fill the blank dynamically. not in the table. 

[stevedep]

Perhaps solve blanks in power query?

[Anonymous]

@stevedep , how? 

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Try:

Replace with Unknown =
VAR _comp_code = MAX('REP EMPLOYEE_DAILY'[COMP_CD_TXT])
RETURN
IF(_comp_code="", "Unknown", _comp_code)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

[rishabh770]

Hi, were you able to find the solution to this?

[ananthabulusu]

Hi, 

Did you get the solution for this blank. Please share once.

[amitchandak]

@Anonymous , You can do in a column, not in the measure  in this case

new COMP_CD_TXT = coalesce([COMP_CD_TXT], "Unknown")

[Anonymous]

@amitchandak , thanks for quick reply.

But in the table, there is no blank value exists. While joining both the tables and creating the visuals from both the tables, the blank value is coming.