Last SoldBy salesperson

[TonyR]

Hi,

Based on the simple table table structure below can some show me an example of the dax forum that will show which salesperson last sold to that customer. It would be added as a column\measure to the customer table.

Thank you

Tony

Invoice 

[DoubleJ]

Hi

I think a new column with this formula should do what you want:

LastSoldBy = LOOKUPVALUE(
    Sales[SalesPerson];
    Sales[InvDate];MAXX(RELATEDTABLE(Sales);Sales[InvDate]);
    Customers[CustomerID];Customers[CustomerID]
    )

I am sure there's a better solution and I am curious to see it myself. Anyway, I hope this helps for now.

JJ

[Vvelarde · Accepted solution]

@DoubleJ

Hi, my alternative solution would be a measure like this:

LastSoldBy =
CALCULATE (
    VALUES ( Sales[SalesPerson] ),
    FILTER ( RELATEDTABLE ( Sales ), Sales[InVDate] = MAX ( Sales[InVDate] ) )
)

[DoubleJ]

Hi Victor 

Thanks for sharing, your solution probably is faster!