Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
3 years ago
Solved

Calculated Column with value from previous week

Hi experts!

I have a table that contains columns like this:

Year-Week Article Value Price Dim 1 Dim 2 Dim 3
2023-01 A 50 2      
2023-02 A 60 2      
2023-03 A 88 2      

 

In this table I would like to add a calculated column that shows me the change in column [Value] vs last week.

How would you do that as a calculated column?

 

 

Need Help
  • ValtteriN's avatar
    ValtteriN
    3 years ago

    Hi,

    Here is one way to do this:

    Last week's value =
    var _YW = [Year-Week] return
    CALCULATE(MAX([value]),ALL('Table (26)'),_YW>'Table (26)'[Year-Week])

    End result:



    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/



1 Reply

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    3 years ago

    Hi,

    Here is one way to do this:

    Last week's value =
    var _YW = [Year-Week] return
    CALCULATE(MAX([value]),ALL('Table (26)'),_YW>'Table (26)'[Year-Week])

    End result:



    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/