dynamic table and columns

[Sejal]

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.

I want to display data of last month. So December’s data in January...then January’s data in February and so on.

So I have created table visual. Inserted 4 columns of 4 weeks .Then 5th column as sum of 4 columns.
How do I display it on table visual so when the column changes , it automatically updates on visual.

so basically we need to change column names on table visual while refreshing columns on table in Exccel.

Please see the attached report. I want to display this type of report on table visual.

waiting for the best solution......

Thanks a lot 

[Sejal]

Thanks a ton for this solution. .it works So Perfect.

[Sejal]

@amitchandak  Oh wow .... it works magically.... So Perfect 🙂

Thanks a ton for this solution. I really  appreciate it.

[amitchandak · Accepted solution]

@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