martijnvanderveldt
New member
- Joined
- Sep 10, 2014
- Messages
- 10
- Reaction score
- 0
- Points
- 0
Heyy
I hope you guys can help me out. I am looking for a formula that groups the volume values of a larger table with DAX:
Outlet 1: Sells 3 of product A
Outlet 1: Sells 4 of Product B
Outlet 1: Sells 3 of Product C
To a smaller table
Outlet 1: Sells 10 Products
Lookupvalue doesn't seem to work since the second table expects single values and not multiples.
I hope you guys can help me out. I am looking for a formula that groups the volume values of a larger table with DAX:
Outlet 1: Sells 3 of product A
Outlet 1: Sells 4 of Product B
Outlet 1: Sells 3 of Product C
To a smaller table
Outlet 1: Sells 10 Products
Lookupvalue doesn't seem to work since the second table expects single values and not multiples.