Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Need to get the same Lookup Value column result.. Can someone help me..?
Country | Sales Rep | Country | Lookup Value | ||
Brazil | Jena | Brazil | Jena, Marie | ||
Brazil | Marie | Canada | Jack, Marie | ||
Canada | Jack | ||||
Canada | Marie |
Regards,
Murali
Solved! Go to Solution.
@Anonymous Please try this as a "New Table"
Test143 = SUMMARIZE(_Emp,_Emp[Deptno],"Names",CONCATENATEX(_Emp,_Emp[Ename],","))
Proud to be a PBI Community Champion
Hi Murali,
A measure solution in a Table visual.
Measure 2 = CONCATENATEX ( VALUES ( Table2[Sales Rep] ), [Sales Rep], "," )
Best Regards,
Dale
@Anonymous Please try this as a "New Table"
Test143 = SUMMARIZE(_Emp,_Emp[Deptno],"Names",CONCATENATEX(_Emp,_Emp[Ename],","))
Proud to be a PBI Community Champion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |