Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 , try a new column
new column =
var _cnt = countx(filter(Table, [Material] = earlier([Material]) && [Store] =1), [Material])
return
if(isblank(_cnt) , "Branch", "Universal")
Awesome, that works out perfectly! Thanks so much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |