In my order capture app, I want to create a virtual column with type list that returns a list of Product Names with same Order Id from a table of Order Details. Much like REF_ROWS() work. I created an virtual column in Orders table but the expression below is not working;
SELECT(Order Details[DS Tracking No], ([Order Id] = [_THISROW].[Order Id]))
Can anyone please help?
User | Count |
---|---|
43 | |
27 | |
23 | |
14 | |
12 |