Forum Discussion

mtrevisiol's avatar
mtrevisiol
Icon for Helper V rankHelper V
4 years ago
Solved

Combine rows according to a column

Hi everyone, I've got a table which contains the list of customers of a company:     Each customer has a code and a name, and some of them change their name over time. My intent is to crea...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • johnt75's avatar
    johnt75
    4 years ago

    Create a new table like

    Filtered Customers = CALCULATETABLE(
	Customers,
	EXCEPT( VALUES( Customers[Code]), VALUES( Customers[OldCode]))
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Create a new table like

Filtered Customers = CALCULATETABLE(
	Customers,
	EXCEPT( VALUES( Customers[Code]), VALUES( Customers[OldCode]))
)
  • mtrevisiol's avatar
    mtrevisiol
    Icon for Helper V rankHelper V
    4 years ago

    Many thanks, it perfectly works!

    I found that an alternative way consists of a "Right anti" merge between Customers.OldCode on power query