Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everybody. Help me plz. I have table with product range. My goal is find first result from lookupvalue, but from the other colums for built PATH().
My example.
Сomponent parts | Product | Code Product | ChildID |
Zubr after test | Zubr | C-0000222 | =LOOKUPVALUE([Code Product];[Product];[Component part]) it's will = > C-0000328 |
Zubr completing | Zubr after test | C-0000328 | need = > C-0000692 |
Power supply | Zubr completing | C-0000692 | - |
Power supply | Zubr completing | C-0000693 |
Solved! Go to Solution.
Hi @bereteli
You should probably refer to the firstnonblank function, please kindly check below thread:
https://community.powerbi.com/t5/Desktop/Lookupvalue-only-first-result/m-p/244009
https://community.powerbi.com/t5/Desktop/LOOKUPVALUE-return-first-of-multiple-matches/m-p/727121
Hi @bereteli
You should probably refer to the firstnonblank function, please kindly check below thread:
https://community.powerbi.com/t5/Desktop/Lookupvalue-only-first-result/m-p/244009
https://community.powerbi.com/t5/Desktop/LOOKUPVALUE-return-first-of-multiple-matches/m-p/727121
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |