Only showing the latest seller while using the LASTDATE function

[JoniH]

Hi!

I have a large database that I've imported to Power BI via a csv file. I'd like to show the customers that haven't made a new order in for example one year, and show that specific date and the salesperson of that order.

I used LASTDATE function with my measure for the Latest invoice column and it works fine, but when I add the seller data it shows every seller's last sale. I want to only show the latest invoice date, no matter the salesperson.



Cheers,
Joni