Calculate Changes from previous cycle

[joshua1990]

Hi all!

I have a table that contains weekly extracts / snapshots of transactional data:

Year-Week Snapshot	Article	Date	Value
2023-01	A	01.01.2023	60
2023-02	B	15.02.2023	50

This table is linked to a simple calendar table.

Then this data is visualized in a simple bar chart with an aggregation on a monthly level.

Now I would like to check the changes vs the previous snapshot.

How would you do that?

[amitchandak]

@joshua1990 , Create a table with only Week snapshot or have that in date table

Create a Rank on the snapshot in the new table or date table

Week Rank = RANKX('Date','Date'[Year Week Snapshot],,ASC,Dense) //YYYYWW format

Then you can compare

This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))