Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
38 | |
26 | |
20 | |
14 | |
8 |
User | Count |
---|---|
71 | |
47 | |
46 | |
20 | |
16 |