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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

One to Many Formula to return first instance

Hi Experts

 

I have two tables A and B. In table A i have unique instance of the values (client names) in table b i have multiple instance of the client names and multiple instance of the business sector they are in, which is the same for each client...

 

I want to return the results of which business sector they are in - into table A and get only one instance....

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hey @Anonymous

 

The FIRSTNONBLANK function should work nicely. It's syntax is FIRSTNONBLANK(Table[Column],1). The ",1" is important to not throw an error.

 

Hope this helps,

Parker

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hey @Anonymous

 

The FIRSTNONBLANK function should work nicely. It's syntax is FIRSTNONBLANK(Table[Column],1). The ",1" is important to not throw an error.

 

Hope this helps,

Parker

Anonymous
Not applicable

thanks Parker 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.