Mailing Names

[Anonymous]

Hi I have a table visual in powerbi where I have a list of members and their address.

For example the data table would look like this:

Firstname  Lastname   Address1 

James         Smith         12345 Universe St

Jenny          Smith         12345 Universe St

John           Jones          4444 whatever st.

what I want to have is add an extra column that contains mailing names in the table visual where if a Spouse lives in the same address it would look like:

Firstname  Lastname   Address1                      Mailing Name

James         Smith         12345 Universe St        James and Jenny Smith

Jenny          Smith         12345 Universe St        James and Jenny Smith

John           Jones          4444 whatever st.         John Jones

If it's a different last name but both lives in the same address it would be:

James Smith and Jenny Lee

How would I go about creating that new column?  

[lbendlin]

Don't go there, too many deep holes that you can't dig yourself out of

- who decides if the male or female family member goes first

- who decides which name is male or female

- what about multi family addresses (multiple Smith's in a highrise for example)

- what if they are family but not on speaking terms

etc etc.

Just don't do it.