Move values 1 week ahead

Hi Robin96 ,

Try this, create the masure below

Measure = CALCULATE(MAX('Table'[Value]),FILTER(ALL('Table'),'Table'[Week]= MIN('Table'[Week])-1))

Shifted Cash Balance = 
VAR Current_week = max('Dimension Date'[Week Number])
VAR Previous_week = Current_week - 1
RETURN
CALCULATE(
    [Totals Lines | Cash balance],
    FILTER(
        ALL('Dimension Date'),
        'Dimension Date'[Week Number] = Previous_week
    )
)

Here is a similar solution for your reference, Solved: Previous period measure (no date) - Microsoft Fabric Community

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.