Move values 1 week ahead

[Robin96]

Hey guys, i have some trouble moving my original values 1 week ahead. Anyone have an easy DAX calculation for this?

This is my desired outcome:

I have tried this measure, but its not giving me the right values, its working for the first column, but not the rest. i think its becasuse i have week number = previous week. Any suggestions to have this measure automated for all the columns and not just one?

VAR Current_week = SELECTEDVALUE('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)

 i have a date table with weeks in it.

[Ashish_Mathur]

Hi,

Does this measure work?

=CALCULATE([Totals Lines | Cash balance],datesbetween('Dimension Date'[date],min('Dimension Date'[date])-7,min('Dimension Date'[date])-1))

[v-rongtiep-msft]

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.

[Robin96]

Hey and thanks for the response,

This did not work.. the values i am trying to shift comes from another measure and not a table, so the max function does not work..

[lbendlin]

Use your dates, rather than weeks.  

[Date]-7