Percent Change of Sales Week Over Week

I have a table with the same item (column 1) over multiple weeks (column 2). Lets say the items types of food at my store (milk, break, eggs). In Column 3 I will populate the number of items sold every week. In Column 4 I want to see the percent change in the number of items sold in the prior week. I have been using the formula based on Row ID, is this correct?

(thisRow.[items sold])-(thisTable.Filter(RowId(thisRow+1)).[items sold])

I am stating by creating a new column to pull the prior values, but not coming to a solution
[This Table].[ Items sold].Filter([Row ID]<thisRow.[Row ID]).Last( )

Hi Morgan,

Welcome to the community!

There would be several ways of solving this, but the RowID doesn’t sound like the most robust solution. I would use a date instead.

Your idea to create a column to pull previous sales is good, but you need to sort it to make sure you get the right one.

Here you have a little demo. Feel free to go through the formulas and let me know if you have any question.

Hope this helps,

Pablo

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.