Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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....
Solved! Go to Solution.
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
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
thanks Parker
User | Count |
---|---|
84 | |
81 | |
72 | |
72 | |
55 |
User | Count |
---|---|
108 | |
105 | |
96 | |
86 | |
68 |