SOLVED

Return last occurrence(DateTime) of certain status filtered by UserName

%3CLINGO-SUB%20id%3D%22lingo-sub-1543160%22%20slang%3D%22en-US%22%3EReturn%20last%20occurrence(DateTime)%20of%20certain%20status%20filtered%20by%20UserName%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543160%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%20community%20if%20anyone%20can%20help%20would%20be%20grateful.%3CBR%20%2F%3EI%20want%20a%20solution%20for%20my%20sector.%3CBR%20%2F%3EI%20need%20to%20follow%20up%20on%20sales.%3CBR%20%2F%3EKnow%20the%20store%20that%20made%20the%20sale%20based%20on%20the%20Mobility%20database%2C%20who%20made%20it%20and%20in%20which%20store%20it%20was%20at%20the%20time%20of%20sale.%3C%2FP%3E%3CP%3Eit's%20possible%20in%20power%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eattached%20an%20idea%20I%20had%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1543160%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EShow%20and%20Tell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1562327%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20last%20occurrence(DateTime)%20of%20certain%20status%20filtered%20by%20UserName%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1562327%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20bases%2C%20one%20comes%20from%20the%20sales%20system%20(with%20the%20name%20of%20the%20seller%20and%20the%20product%20sold%20as%20well%20as%20date)%20and%20the%20other%20has%20contains%20the%20name%20of%20the%20seller%20and%20the%20stores.%3C%2FP%3E%3CP%3EI%20can%20already%20list%20them%20through%20the%20name%20of%20the%20seller.%3C%2FP%3E%3CP%3Emy%20difficulty%20is%20when%20the%20seller%20temporarily%20changes%20stores%2C%20I%20would%20like%20to%20know%20in%20stores%20the%20sale%20was%20made%20during%20the%20exchange%20period%3C%2FP%3E%3CP%3Ethis%20is%20possible%20in%20powerquery%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564783%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20last%20occurrence(DateTime)%20of%20certain%20status%20filtered%20by%20UserName%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735858%22%20target%3D%22_blank%22%3E%40Gildo_Pinheiro%3C%2FA%3E%26nbsp%3BPerhaps%20the%20attached%20PQ%20solution%20is%20what%20you%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564932%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20last%20occurrence(DateTime)%20of%20certain%20status%20filtered%20by%20UserName%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564932%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bfirst%20of%20all%20thank%20you%20for%20being%20available%20to%20help%2C%20I%20am%20very%20grateful%20this%20is%20important%20to%20me.%3C%2FP%3E%3CP%3Ethe%20little%20I%20had%20access%20goes%20according%20to%20the%20solution%20I%20need%3C%2FP%3E%3CP%3EI%20use%20MSO%20Professional%20plus%202016.%3C%2FP%3E%3CP%3Ebut%20I%20don't%20find%20the%20Fuzzy%20function.%3C%2FP%3E%3CP%3EIt%20would%20be%20possible%20to%20achieve%20the%20same%20result%20without%20us%3CSPAN%3Eing%20the%20Fuzzy%20function%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564963%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20last%20occurrence(DateTime)%20of%20certain%20status%20filtered%20by%20UserName%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735858%22%20target%3D%22_blank%22%3E%40Gildo_Pinheiro%3C%2FA%3E%26nbsp%3BOkay.%20Am%20not%20familiar%20with%20older%20PQ%20versions.%20The%20fuzzy%20matching%20was%20needed%20because%20the%20employee%20names%20in%20both%20lists%20were%20not%20consistent.%20If%20you%20can%20make%20them%20consistent%20(or%20better%2C%20add%20unique%20employee%20numbers)%20in%26nbsp%3B%3CSTRONG%3Eboth%3C%2FSTRONG%3E%20lists.%20Then%20you%20don't%20need%20the%20%22fuzzy%22%20step.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566839%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20last%20occurrence(DateTime)%20of%20certain%20status%20filtered%20by%20UserName%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566839%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much%20problem%20solved%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 and in which store it was at the time of sale.

it's possible in power query.

 

attached an idea I had

5 Replies

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

@Gildo_Pinheiro Perhaps the attached PQ solution is what you need.

 

Hello @Riny_van_Eekelen first of all thank you for being available to help, I am very grateful this is important to me.

the little I had access goes according to the solution I need

I use MSO Professional plus 2016.

but I don't find the Fuzzy function.

It would be possible to achieve the same result without using the Fuzzy function

best response confirmed by Gildo_Pinheiro (Occasional Contributor)
Solution

@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.

hello @Riny_van_Eekelen Thank you very much problem solved