transpose
5 TopicsCreate new table by transposing/Crosstab a data table
Hi, I need to crosstab/transpose data from one table to create a new table as shown in example below. Original Table: User Week Status A1 Week1 Active A1 Week2 Inactive A1 Week3 Deleted A2 Week1 Active A2 Week2 Active A2 Week3 Deleted A3 Week1 Active A3 Week2 Active A3 Week3 Active A4 Week3 Idle A5 Week2 Active A5 Week3 Active New Table/Changed format/Desired output: User Week1 Week2 Week3 A1 Active Inactive Deleted A2 Active Active Deleted A3 Active Active Active A4 Idle A5 Active Active Can anyone help me with the same? Thanks in advance.Solved2.9KViews1like5CommentsTranspose or Upivot?
Hello everyone, I am hoping someone can help me with transposing or unpivoting some columns. I am basically trying to turn this: Into this in Power Query Editor: I've tried unpivoting a few different ways, but no luck with attaching the reponse and the commentary to the same Question and ID. Any help would be appreciated. Thanks!Solved1.2KViews0likes3CommentsTransposing / Transforming data with DAX
I want to transform the data from this format: ID CaseNumber Asset1 Asset2 AA BB 1 2 CC DD 3 4 To this format: ID CaseNumber Asset Value AA BB Asset1 1 AA BB Asset2 2 CC DD Asset1 3 CC DD Asset2 4 Since columns Asset1, Asset2, Asset3, etc. are calculated column in DAX I cannot use PowerQuery to unpivot the data. Let me know any solutions with DAX. Thanks!!Solved1.1KViews0likes5CommentsTransponer valores de filas en columnas en una tabla con DAX
Estimados Buenas tardes, tengo la siguiente tabla, donde tengo ventas de productos en 2 años respectivos. Necesito que los valores que estan como fila dejarlos como una columa respectiva Desde ya muchas gracias a las respuestas, lo he intentado, pero no logro dar con el resultado esperado. Saludos AlvaroSolved2KViews0likes4CommentsFetching column names from table
Hi All, wanted to fetch all the column names from a particular table, either as a row in that same table or as a measure. I was hoping to have all the column names as a selectable value in the table, rather than just a heading. Also if possible somehow have a table rows and coulmns interchanged as in transposing them. Thank you829Views0likes0Comments