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

Anonymous — Wed, 06 May 2020 15:41:10 GMT

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

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

d_gosbell — Tue, 05 May 2020 22:21:24 GMT

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

topic I am trying to do an If/Then referencing another row in Report Server

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

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