Add a (Code) column if Same Product ID

[SkorpionAAM]

I have Two Table one have Records and one have Company Names in Records I have Code and Product codes where company receive the Product and then Transfer to Parcel Department where code changed and then next step will take where product status changed to Ready for Delivery than Loaded and in the end product will Delivery its last stage I need to add one more column where apply if product is same then Company Id will add and company code is on top each product where is Mention Company so that code will add in new Column with each step . thansk

Google Sheet

https://docs.google.com/spreadsheets/d/1jUElkVme4u9s_LByT6LYICsw88i-8UrVvoigwyrIw5E/edit?usp=sharing

[SkorpionAAM]

?????????????

[SkorpionAAM]

??????????????

[amitchandak]

@SkorpionAAM , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Mark me @

[SkorpionAAM]

r u there ??/

[SkorpionAAM]

Google Sheet

https://docs.google.com/spreadsheets/d/1jUElkVme4u9s_LByT6LYICsw88i-8UrVvoigwyrIw5E/edit?usp=sharing


Power BI

https://drive.google.com/file/d/1futE9F6syAuZirm6wDfKBcwvml03Dy8w/view?usp=sharing

[SkorpionAAM]

Any one ??

[SkorpionAAM]

Almost okay but i need every Code check Google sheet OutPut should be like this (Column G) i need that output each code bcz data will come more so i need every company recordds how many HD bare code they recied and tracking check the Blue background Comun i need like this 

[Anonymous]

Hi @SkorpionAAM ，

Could you please share  the calculation logic of Column G in your Google sheet with us in order to provide you a suitable formula? It equals to the access code with oldest date in same [HD Barre Code]? Which conditions need to satisfy when obtain column G value?

Best Regards

[amitchandak]

@SkorpionAAM , based on what I got, Try a new column in DAX( Not power Query)

New column =
var _min = minx(filter(Table, [Hd Barre Code] = earlier([Hd Barre Code])), [submission Date])
return
maxx(filter(Table, [Hd Barre Code] = earlier([Hd Barre Code]) && [submission Date]=_min), [Enter your Access Code])