Refreshing the Dashboard if dates are added weekly by Columns

[Rambo92]

Hi All,

I need some help in refreshing this data in powerbi. The dates are added every week so as the numbers below. I tried to build the dashboard to see the performance. But if new date in addded in the next column, it is not refreshing showing error that the column is missing. I tried to resolve that in advanced formula bar, I just wanted to check is there any way without added the new date in the advanced formula bar every time we add new column.

I have tried to unpivot all columns so that it would be easier to analyse.

Thanks in Advance. Please let me know if anything else needed on this.