Summarize tags from orders to customers table

[Elache]

Hello,
I want to group in my "Customer" table the tags that are assigned to customers in my "Orders" table. They are always the same tags that are assigned so there is no risk of duplication but I can't manage to do it. My ideal output is as follows:

ORDERS			CUSTOMERS
Client	Tag		Client	Tag
A	1		A	1
B	2		B	2
C	3		C	3
A	1
A	1
B	2

Thank you very much for any help!
Have a nice day

[Elache]

It's perfect! Thank you so much

[FreemanZ · Accepted solution]

hi @Elache 

Tag =

VAR _client = [Client]

RETURN

MINX(

    FILTER(Orders, Orders[Client]=_client),

    Orders[Tag]

)

[Elache]

Hey @JorgePinho 
Thank you for your answer!
I want to add this to my existing customer table as a column. For information, my tag is a non numerical value.
Thank you!

[JorgePinho]

Hey @Elache! Try this DAX for a new table:

Table = SUMMARIZE(ORDERS, [Client], MAX(Tag))