Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
adityah
Frequent Visitor

How to find a value with multiple conditions

I have a table which looks something like this

 

Renewal_IDOffer_idGeneral_excess
12677130000
12677210000
12677020000
12712730000
12712810000
12712020000

 

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_IDOffer_idGeneral_excessGeneral_excess_o
1267713000020000
1267721000020000
1267702000020000
1271273000020000
1271281000020000
1271202000020000

 

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

1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors