Forum Discussion
offset to shift values up a level
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 |
Anonymous , if they are columns in table Offset can not help. Do data correction in power query
for offset, you have unpivot the data
1 Reply
Anonymous , if they are columns in table Offset can not help. Do data correction in power query
for offset, you have unpivot the data