Forum Discussion
Transpose table in report visual
The source data should always be equal. But you are right. Transformation steps won't be duplicated.
If this is your intenstion use reference (one below) instead of duplicate.
Then the source of your second query isn't the original source (database?) but the first query.
Every transformation step will be "forwarded" to your new query. So you'll keep all your changes and only unpivot the second query.
Hi webportal,
Agree with supder, the current table structure doesn't match the matrix visual. To achieve your goal, you have to unpivot columns, as it is not available to do that using DAX, as supder mentioned, the best choice is duplicating your source table.
Best regards,
Yuliana Gu
Hi,
I know it doens't match the matrix. The problem is that by duplicating and unpivoting the table, I'll have two tables which are not synchronized. That is, changes in the original table will not be reflected on the tranposed table.
The source data should always be equal. But you are right. Transformation steps won't be duplicated.
If this is your intenstion use reference (one below) instead of duplicate.
Then the source of your second query isn't the original source (database?) but the first query.
Every transformation step will be "forwarded" to your new query. So you'll keep all your changes and only unpivot the second query.