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?
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( )