offset to shift values up a level

[Anonymous]

Hi Experts 

Is it possible to shift the values up a level in the following columns (See below) using the Offset function in Power Bi

from the image below i want to move up values in column 21.09.20, 28.09.20 and 05.10.20 to date 01/01/2019.

See Image

Date	Region	14/09/2020	21/09/2020	28/09/2020	05/10/2020
01/01/2019	Scotland	6613
01/02/2019	Scotland	6716
01/03/2019	Scotland	7171
01/04/2019	Scotland	7295
01/05/2019	Scotland	5719
01/06/2019	Scotland	5499
01/07/2019	Scotland	5064
01/01/2020	Scotland		5050	5072	6070
01/02/2020	Scotland		7290	6095	6621
01/03/2020	Scotland		5345	5300	6040
01/04/2020	Scotland		7043	5580	5194
01/05/2020	Scotland		5871	6741	7468
01/06/2020	Scotland		6941	6004	6450
01/07/2020	Scotland		7349	6840	5715

[amitchandak · Accepted solution]

@Anonymous , if they are columns in table Offset can not help. Do data correction in power query

for offset, you have unpivot the data