Forum Discussion
Solved
dynamic table and columns
Hi I have a dynamic table in excel. It keeps changing every month. It has columns of all weeks. The columns keeps changing every month. I want to display the data of latest 4 weeks and 8 weeks. ...
Sejal , Make sure it is marked as a table in excel. While loading instead of table use the table option below
I think, You need to use unpivot other in power bi and then use Matrix visual to pivot again
https://radacad.com/pivot-and-unpivot-with-power-bi
amitchandak Oh wow .... it works magically.... So Perfect 🙂
Thanks a ton for this solution. I really appreciate it.