Create new column with last seller name by date

[Syndicate_Admin]

Hello, I am new here, but I can not solve this, I need to create a new column with the data of another column name of the seller but filtered by the most recent date, I leave reference image

the data are:

Customer	Date	sale	NombreVendedor
Cliente1	10-10-2020	5	Vendedor1
Cliente1	05-01-2022	4	Vendedor2
Cliente1	03-03-2021	8	Vendedor1
Cliente2	10-05-2022	2	Vendedor2
Cliente2	15-04-2022	5	Vendedor1
Cliente2	10-10-2021	9	Vendedor1
Cliente3	05-06-2020	4	Vendedor1
Cliente3	09-09-2022	2	Vendedor2
Expected result				NewCol
Customer	Date	sale	NombreVendedor	Last seller name
Cliente1	10-10-2020	5	Vendedor1	Vendedor2
Cliente1	05-01-2022	4	Vendedor2	Vendedor2
Cliente1	03-03-2021	8	Vendedor1	Vendedor2
Cliente2	10-05-2022	2	Vendedor2	Vendedor1
Cliente2	15-04-2022	5	Vendedor1	Vendedor1
Cliente2	10-10-2021	9	Vendedor1	Vendedor1
Cliente3	05-06-2020	4	Vendedor1	Vendedor2
Cliente3	09-09-2022	2	Vendedor2	Vendedor2

I appreciate any help

Best regards!!!!!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Last seller name CC =
MAXX (
    FILTER (
        Data,
        Data[Customer] = EARLIER ( Data[Customer] )
            && Data[Date]
                = MAXX (
                    FILTER ( Data, Data[Customer] = EARLIER ( Data[Customer] ) ),
                    Data[Date]
                )
    ),
    Data[NombreVendedor]
)