Forum Discussion

Robin96's avatar
Robin96
Helper II
2 years ago

Move values 1 week ahead

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.

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Robin96
      Helper II
      2 years ago

      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..

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    Does this measure work?

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