Forum Discussion
Arrange Row & Column in Matrix Visual
Hi All, I have Table A as picture below. How can I arrange those rows and column in Table A to the Matrix below. Anyone have any idea? I'm prefer to use measure instead of transform the table in ...
Hi Anonymous
You can create duplicate table then you can pivot only one table. and on other table you can create calcuation.
I hope this would work for you.
example of the things that i would like to calculate/display further is to display rolling 12 month of the data (imagine there is a date table). I have try to pivot using powerquery but I cannot display rolling 12 month for the data