Need help getting a equation to work.

Power BI has no concept of row numbers or column numbers, or things like "previous row" or "previous column".  You need to help it by providing index columns, and then you write your measures by including the index values in your filters.

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.