Forum Discussion

InsightSeeker's avatar
InsightSeeker
Icon for Helper III rankHelper III
2 years ago
Solved

Need help with measure

Hello - I need help to create a measure as described below:   If the 'Table 1 Supplier' is equal to the 'Table 1 Supplier', return the supplier code from 'Table 1'.   Table 1   Supplier Co...
Need Help
Show and Tell
  • InsightSeeker's avatar
    InsightSeeker
    2 years ago

    Hi rajendraongole1  - I want to acheive this thorugh measure instead of calculated column, is it possible?

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi InsightSeeker -Create a new column in table 2 uses LOOKUPVALUE to search 'Table 1' for the matching 'Supplier' and returns the corresponding 'Supplier Code'.

 

calculated column:

 

Result1 (Supplier Code) =
LOOKUPVALUE(
    'SP1'[Supplier Code],
    'SP1'[Supplier], 'Sp2'[Supplier]
)

 

 

 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!