Forum Discussion

v_franz's avatar
v_franz
Icon for Helper I rankHelper I
5 years ago

Order Aggregation

Hello,   i would love to display the stardard oders our clients make on our webshop. Is there a possibility to aggregate this data in powerbi?   So that I see: Clients usually order: 1 product...
Need Help
v_franz's avatar
v_franz
Icon for Helper I rankHelper I
5 years ago

Hello Anonymous 

 

thank you for your replay

 

Sample data:

 

Order1 - product A

Order1 - product B

Order1 - product C

Order1 - product D

 

 

Order2 - product A

Order2 - product F

Order2 - product B

Order2 - product Z

 

 

Order3 - product F

Order3 - product C

Order3 - product A

Order3 - product Z

 

...

 

now I want to know, what is the usual composition of our orders to have an Idea for our logistics what should be the most suitable packaging. So it should be grouped by order and by products.

 

I hope everything is clear now 🙂 Otherwise just let me know, so I'll try to explain it better 🙂

 

Thank you.

Best wishes

V.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v_franz ,

I'm still not clear about your requirement... What is the usual composition of the order you mentioned? Do you want to get the product composition of each order just like the screenshot below?

Could you please share the sample data in your model  and expected results with me in the following format?

Sample data

Order Product
Ord1 A
Ord1 B
Ord2 C
... ...

Expected result with specific examples and backend logic

Order Usual composition of the order
Ord1 ?
Ord2 ?
... ...

Best Regards