Forum Discussion
Solved
Return last occurrence(DateTime) of certain status filtered by UserName
hello community if anyone can help would be grateful. I want a solution for my sector. I need to follow up on sales. Know the store that made the sale based on the Mobility database, who made it a...
Gildo_Pinheiro Okay. Am not familiar with older PQ versions. The fuzzy matching was needed because the employee names in both lists were not consistent. If you can make them consistent (or better, add unique employee numbers) in both lists. Then you don't need the "fuzzy" step.
I have 2 bases, one comes from the sales system (with the name of the seller and the product sold as well as date) and the other has contains the name of the seller and the stores.
I can already list them through the name of the seller.
my difficulty is when the seller temporarily changes stores, I would like to know in stores the sale was made during the exchange period
this is possible in powerquery