Forum Discussion
Creating a Column for Combo Orders Vs Single Order
Hello
I am new to POWER BI and trying to cerate a columns for Orders that conatin multiple items as "Combo order" and the one that has one item as "single order".
The tables are as indiacted below
Order Table
| Id | Date Created |
| 1 | 6/23/2021 |
| 2 | 6/23/2021 |
| 3 | 6/22/2021 |
OrderItem Table
| Id | Date Created | OrderID |
| A | 6/23/2021 | 1 |
| B | 6/23/2021 | 1 |
| C | 6/23/2021 | 2 |
| D | 6/23/2021 | 2 |
| E | 6/22/2021 | 3 |
Can someone help me with this?
2 Replies
Try doing a groupby.
Right click on your data source, go to "Edit Query".
At the top, before or after your cleansing of data, you can click "Group By".
This will let you organize your data by grouping it, based on Order.
Swiftglade The data is grouped in the order item table, But I need a column to show next to each order/order item if it is a Combo order or Single order
