Forum Discussion
Create New Table and Column from existing Table with filters
Hi Community,
I am very new to Power Bi. I am trying to create a new table from existing table and add additional column from the new table?
I have tried summarizecolumn with filter but the results is not really what I expected as it only give one answer. Apprecite your help on this.
Below is my sample data set.
What I want to do is to create a new table by selecting
1) "Voice" on SERVICETYPE column and
2) "New" fon SEGMENT column
I also want my Network Type i.e Local, Onnet and IDD become header for volume. The result should be something like below.
| STAT CYCLE | DIVISION | REGION | SERVICE TYPE | SEGMENT | IDD | Local | Onnet |
| 31/5/2018 | Marketing | Central | Voice | New | 278 | 36598 | 12052 |
| 31/5/2018 | Marketing | Northern | Voice | New | 15 | 6691 | 2233 |
| 31/5/2018 | Marketing | Southern | Voice | New | 763 | 11737 | 4786 |
| 31/5/2018 | Sales | Central | Voice | New | 1315 | 32539 | 12200 |
| 31/5/2018 | Sales | Northern | Voice | New | 148 | 13600 | 4110 |
| 31/5/2018 | Sales | Southern | Voice | New | 623 | 15924 | 6703 |
| 30/6/2018 | Marketing | Central | Voice | New | 308 | 35457 | 11374 |
| 30/6/2018 | Marketing | Northern | Voice | New | 35 | 8080 | 2046 |
| 30/6/2018 | Marketing | Southern | Voice | New | 271 | 11610 | 4428 |
| 30/6/2018 | Sales | Central | Voice | New | 1610 | 30701 | 11716 |
| 30/6/2018 | Sales | Northern | Voice | New | 12002 | 2863 | |
30/6/2018 | Sales | Southern | Voice | New | 418 | 14787 | 5632 |
Could anyone help?
Thanks.
Madi
Hi MADI_IDRIS,
This can be achinved by going to Power Query Editor.
For Creating new table with the same datasource:
1. Right Click on the Query Souce and duplicate it, then in the another duplicated table you can apply your filter and then click on close and apply. This way you can create new table from the same source with filter that you like.
2. For Making you Network Type column as header you need to use do Pivot in the Power Query Editor.
refer to this : https://community.powerbi.com/t5/Community-Blog/Pivot-your-Data-using-Power-Query/ba-p/224019Thanks
Anonymous wrote:Hi MADI_IDRIS,
This can be achinved by going to Power Query Editor.
For Creating new table with the same datasource:
1. Right Click on the Query Souce and duplicate it, then in the another duplicated table you can apply your filter and then click on close and apply. This way you can create new table from the same source with filter that you like.
2. For Making you Network Type column as header you need to use do Pivot in the Power Query Editor.
refer to this : https://community.powerbi.com/t5/Community-Blog/Pivot-your-Data-using-Power-Query/ba-p/224019Thanks jayant.. Really Appreciate your fast and exact solution.
2 Replies
Hi MADI_IDRIS,
This can be achinved by going to Power Query Editor.
For Creating new table with the same datasource:
1. Right Click on the Query Souce and duplicate it, then in the another duplicated table you can apply your filter and then click on close and apply. This way you can create new table from the same source with filter that you like.
2. For Making you Network Type column as header you need to use do Pivot in the Power Query Editor.
refer to this : https://community.powerbi.com/t5/Community-Blog/Pivot-your-Data-using-Power-Query/ba-p/224019Thanks
Anonymous wrote:Hi MADI_IDRIS,
This can be achinved by going to Power Query Editor.
For Creating new table with the same datasource:
1. Right Click on the Query Souce and duplicate it, then in the another duplicated table you can apply your filter and then click on close and apply. This way you can create new table from the same source with filter that you like.
2. For Making you Network Type column as header you need to use do Pivot in the Power Query Editor.
refer to this : https://community.powerbi.com/t5/Community-Blog/Pivot-your-Data-using-Power-Query/ba-p/224019Thanks jayant.. Really Appreciate your fast and exact solution.