Forum Discussion

Luizcarlospf's avatar
Luizcarlospf
Helper I
5 years ago
Solved

Overwrite empty columns by default values

  To put it in context: I have 2 related tables, but not all lines are related. When I go to view all the values of the tables in an array, I have empty values (names) As you can see in the i...
General Comment
Need Help
Show and Tell
  • timg's avatar
    timg
    5 years ago

    Hi Luizcarlospf,

    The clean solution to this would be to add a record in your [seller name] column with an unused ID (e.g. -1) and "not registered" as seller name. Then to map all the records who currently do not have a seller associated with them to that new ID. Below you'll find an example:

    1

    2

    Hope that helps!

    Regards,

    Tim

Luizcarlospf's avatar
Luizcarlospf
Helper I
5 years ago

the whole problem is the relationship  between the tables that I am using. There are sales unrelated to the seller. changing the tables would be impossible due to the large number of empty values. I need a solution with filter or metrics to just change the empty value for some standard name

timg's avatar
timg
Solution Sage
5 years ago

Hi,

Regarding my earlier solution, within Power query you could use the replace value function replace all empty values at once. 

However, if this is not a fitting solution in this case, you could create a calculated column in the sales table and have it filled with the RELATED() value from the seller table and use a SWITCH() to replace the blanks with a different value.

Regards,

Tim