Forum Discussion
GCGradwell
Helper I
Helper IConcatenate 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. ...
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
Responsive Resident
Responsive ResidentAs 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]))
GCGradwellHelper I
Helper IFantastic! Excellent solution, I really appreciate the help.
Massive thanks!
Greg