Need Unknown instead of blank

[bdehning]

I have Table with Class Code and Description.  Class Code and Description reside in different tables.  

The column Description fills in from Class Code.   I was able to create Unknown for Blank for Class Code.

So I do create a Custom Column or Conditional Column to get Description to show Unknown instead of blank?

[Idrissshatila · Accepted solution]

Hello @bdehning ,

You could in power query replace blanks with unknown using the replace values function,

check this link for instructions https://learn.microsoft.com/en-us/power-query/replace-values

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[bdehning]

I am not sure who marked it solved.  But not solved, as not as simple to just use replace values. 

As explained, Class Code and Description are in two different tables and Description does not contain any null values.   

Description is determined from Class Code value and I have to select last when Description is placed as a column.  I was able to replace Null in Class Code with unknown.   

When Class Code encounters a null value is correctly displays Unknown in the table, but Description leaves a blank and it has no way to assign a value for null or unknown as it does not contain either. 

Since Description is a on table on Server, how could I add a Row to this table to insert a Row that has null value.   That seems it may work, right?