Calculated Column with value from previous week

[joshua1990]

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?

[ValtteriN · Accepted solution]

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/