Forum Discussion

GCGradwell's avatar
GCGradwell
Icon for Helper I rankHelper I
10 years ago
Solved

Concatenate data into new column using heirarchies

Hi,   I am trying to create a new column which concatenates data from two different columns. These columns are in different tables and are linked to each other by relationships within Power BI.   ...
Need Help
  • chrisu's avatar
    chrisu
    10 years ago

    As stated above, you'd need a calculated column.  In my own data with a similar setup (pulling the "one" side to a "many" side of a relationship two tables away), I was able to do this using a single formula that looks like this:

     

    IDDepartment = CONCATENATE(Invoices[Customer ID], RELATED('Product Class'[Department]))

     

     

chrisu's avatar
chrisu
Icon for Responsive Resident rankResponsive Resident
10 years ago

As stated above, you'd need a calculated column.  In my own data with a similar setup (pulling the "one" side to a "many" side of a relationship two tables away), I was able to do this using a single formula that looks like this:

 

IDDepartment = CONCATENATE(Invoices[Customer ID], RELATED('Product Class'[Department]))