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?
How about:
[Order Details][DS Tracking No]
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |