Mailing Names

Anonymous — Thu, 25 Jun 2020 18:14:38 GMT

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?

Re: Mailing Names

lbendlin — Fri, 26 Jun 2020 01:54:24 GMT

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.

topic Mailing Names in Developer

Mailing Names

Re: Mailing Names