How to find a value with multiple conditions

[adityah]

I have a table which looks something like this

Renewal_ID	Offer_id	General_excess
12677	1	30000
12677	2	10000
12677	0	20000
12712	7	30000
12712	8	10000
12712	0	20000

This is just a snapshot and there are multiple renewal_id's and offer_id's. I am trying to add a new column which captures the general_excess for offer_id = 0 for each renewal_id column. it should look something like this:

Renewal_ID	Offer_id	General_excess	General_excess_o
12677	1	30000	20000
12677	2	10000	20000
12677	0	20000	20000
12712	7	30000	20000
12712	8	10000	20000
12712	0	20000	20000

I tried using lookupvalue but that results in multiple values being returned. Sorry if this question seems very trivial but I am just learning powerbi. Any help will be appreciated!

Thanks

[amitchandak]

@adityah , A new column

maxx(filter(Table, [Renewal_ID] = earlier([Renewal_ID])  && [Offer_id] =0) , [General_excess])

[adityah · Accepted solution]

Hey, yes this seems to work. Thank you!!