Create New Table and Column from existing Table with filters

[MADI_IDRIS]

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

[Anonymous · Accepted solution]

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/224019

[Anonymous · Accepted solution]

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/224019

[MADI_IDRIS · Accepted solution]

Thanks

---

@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/224019

---

Thanks jayant.. Really Appreciate your fast and exact solution.