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.
hey all
i have a table that contains information in the following format:
ID | CUSTOMFIELD | STRINGVALUE |
569590 | 18111 | text 1 |
569590 | 18301 | text 2 |
569590 | 18419 | 34783 |
569590 | 18420 | 34786 |
569590 | 18421 | 34789 |
569590 | 18422 | 34790 |
569590 | 18423 | 34795 |
569590 | 18424 | 34798 |
569590 | 18433 | 34823 |
569590 | 18434 | 34828 |
569590 | 18435 | 34925 |
569591 | 18111 | text1 |
569592 | 18111 | text2 |
569594 | 18111 | text3 |
569594 | 18419 | 34783 |
569594 | 18420 | 34786 |
569594 | 18421 | 34789 |
569594 | 18422 | 34790 |
569594 | 18423 | 34795 |
569594 | 18424 | 34798 |
569594 | 18426 | 34802 |
569594 | 18427 | 34929 |
569594 | 18428 | 34810 |
569594 | 18429 | 34945 |
569594 | 18430 | 34815 |
569594 | 18431 | 34818 |
569594 | 18432 | 34820 |
569594 | 18433 | 34823 |
569594 | 18434 | 34826 |
569594 | 18435 | 34831 |
lets call this table CUSTOM i have a second table called MAIN that links to CUSTOM in a one to many relationship based on the ID field. As you can see there can be a large number of rows in CUSTOM that have the same ID
i know it might be hard to visualize but for multiple reasons i need to create a new column in MAIN that contains the value from CUSTOM[STRINGVALUE] when CUSTOM[CUSTOMFIELD]=18111 AND MAIN[ID] = CUSTOM[ID]
i have been trying various things using posts ont his forum but i have not been able to make this work, any help would be appreciated
Solved! Go to Solution.
Take a look at using the dax function LOOKUPVALUE it works in very much the same way as vlookup in Excel and should help you solve your problem.
https://msdn.microsoft.com/en-us/library/gg492170.aspx
Let me know how you get on.
Hi @bleysamber,
Could you please mark the proper answer if it's convenient for you? That will be a help to the others.
Best Regards!
Dale
Take a look at using the dax function LOOKUPVALUE it works in very much the same way as vlookup in Excel and should help you solve your problem.
https://msdn.microsoft.com/en-us/library/gg492170.aspx
Let me know how you get on.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |