Forum Discussion
Create a transposed table from an existing table
I solved like this:
Copied the original table.
In the copied table selected the 10 KPI columns and unpivot them.
Renamed The Attribute Colum to KPI
Clicked “Create New table” in the data model and used the summarize function as follow:
SummarizedRAG =
SUMMARIZE(
'DB (3)',
'DB (3)'[KPI],
"RedCount", COUNTROWS(FILTER('DB (3)','DB (3)'[Value]="Red")),
"AmberCount", COUNTROWS(FILTER('DB (3)','DB (3)'[Value]="Amber")),
"GreenCount", COUNTROWS(FILTER('DB (3)','DB (3)'[Value]="Green"))
)
Hello Alicito,
You can use power query for that
1. Go to transform Data
2. Go to transform tab, Now select all three colum of your data i.e Red, Amber, Green.
3.Under "Any column" section you will find Unpivot column. click on Unpivot colum.
4. now your data will be divided to 3 three columns KPI, Attribute & Values.
5. you can rename Attribute and values column as per your need.
I hope this will be helpfull.
kiran_jadhav The problem is to change the data in first image to data in second image.
