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.
I have two tables
Table 1 (Datasource SQL - 100 rows) - Computer Name
Table 2 (Datasource is CSV - 2000 rows) - Computer Name
Created relationship between these two using the Computer Name column, Many to Many and Both.
Now i have to do a lookupvalue search between these two Tables.
First in Table 1 I created a column (DAX) - Lookupvalue (Table2.ComputerName,Table1.ComputerName,Table1.ComputerName) - This is success.
Now if I do vice versa i am not able to write he formula. Dont know why seriously...
Trying to create a column in Table 2 - Lookupupvalue (Table1.ComputerName,Table2.ComputerName,Table2.ComputerName) - But I am not able to write Table2.ComputerName,Table2.ComputerName since the name is not popping up in DAX formula editor for adding to the formula.
Solved! Go to Solution.
Hi @Anonymous ,
By my tests, I cannot reproduce your issue.
More details, you could refer to my attachment.
If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
Hi @Anonymous ,
By my tests, I cannot reproduce your issue.
More details, you could refer to my attachment.
If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
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 |
---|---|
113 | |
103 | |
77 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |