transpose
3 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.9KViews1like5CommentsTransposing / 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 AlvaroSolved2KViews0likes4Comments