I am trying to do an If/Then referencing another row

[Anonymous]

Expanded explanation--

In this data I want to do something like:

if team on row a = team on row b

and end of week on row a = end of week on row b - 7

then put the net change amount from row a into a field named 'running total' on row b

I am trying to write the following:
If the field PriorWeek in this row equals the EndDate in another row, put in the NetAmount from the other row as PriorAmount.
ie:  if the Net Amount for 5/1/20 is 50, put that as PriorAmount in the row for 5/8/20

[d_gosbell]

There is not enough information to be able to answer you question well.

Can you post some example data following the suggestions outlined in the following link:

How to Get Your Question Answered Quickly - Microsoft Power BI Community