Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@adityah , A new column
maxx(filter(Table, [Renewal_ID] = earlier([Renewal_ID]) && [Offer_id] =0) , [General_excess])
Hey, yes this seems to work. Thank you!!
User | Count |
---|---|
57 | |
21 | |
19 | |
18 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |