Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to find a value with multiple conditions
11-13-2022
07:16 PM
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.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2022
10:57 PM
Hey, yes this seems to work. Thank you!!

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
06-10-2024 01:16 AM | |||
Anonymous
| 07-05-2024 09:35 AM | ||
08-26-2024 02:49 AM | |||
04-16-2024 07:40 PM | |||
07-18-2024 12:27 PM |