Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a very simple data structure that contains 1) the unique product id and 2) the Category this product belongs to.
I need to transfer this into an aggregated view of the category whose values are the unique product id's that category represents.
Table 1: What I have
product ID | Product Category |
10 | Shavers |
11 | Scissors |
12 | Trimmers |
13 | Shavers |
14 | Shavers |
15 | Scissors |
Table 2: What I need
Product Category | Contained in |
Shavers | 10, 13, 14 |
Scissors | 11, 15 |
Trimmers | 12 |
Of course I have to do it dynamically as we keep adding products and categories so the ledger is massive.
Would appreciate any help or ideas!
Solved! Go to Solution.
@lochoad , Create a measure and use in visual
concatenatex(Table, Table[product ID], ",")
Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43
@lochoad , Create a measure and use in visual
concatenatex(Table, Table[product ID], ",")
Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |