Create New Table and Column from existing Table with filters

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

---

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.