Forum Discussion
joshua1990
Post Prodigy
Post ProdigyCalculated 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
...
Hi,
Here is one way to do this:Last week's value =var _YW = [Year-Week] returnCALCULATE(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/
ValtteriN
Community Champion
Community ChampionHi,
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:
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/