Identify duplicates and apply the category name for them

[Judy-0606]

Hello, 

I have a table containing the duplicate materials that are stocked in different stores.   I need to identify duplicate materials and if this material is stocked at store 1 as well as the rest of the stores, which will be categorized as "Universal".   If the material is only stocked at stores except store 1, which will be categorized as "branch".

Current Table

Store	Material
1	127
2	127
3	127
4	127
5	127
2	128
3	128
4	128
5	128

what I want to achieve is as below.

Store	Material	Type
1	127	Universal
2	127	Universal
3	127	Universal
4	127	Universal
5	127	Universal
2	128	Branch
3	128	Branch
4	128	Branch
5	128	Branch

Thanks 

[amitchandak · Accepted solution]

@Judy-0606 , try a new column

new column =
var _cnt = countx(filter(Table, [Material] = earlier([Material]) && [Store] =1), [Material])
return
if(isblank(_cnt) , "Branch", "Universal")

[Judy-0606]

Awesome,  that works out perfectly!  Thanks so much!