Forum Discussion
Transformation for this table type
Hi,
I have a question. How would I be able to use this kind of tables to transform?
I want to do a combination and make sure once i choose a metric, i can then transform to a chart easily.
Anonymous
you can do the same say
then you can split the column to get year and month
pls see the attachment below
9 Replies
Anonymous
in PQ, you can try to select the first column and unpivot other columns