Forum Discussion
Creative_tree88
Helper V
Helper VLookup Based on a specific field
Hi - I have some data (summarised example linked to this message). I can use the usual lookupvalue formula to get basic info:
Lookup = LOOKUPVALUE('LookupData'[Type], 'LookupData'[Event Key],'Master Data'[Event key])
However, I really need to only lookup the values relating to 'Current Week' field in the 'Lookup Data' dataset. Can you please advise the best formula to do this please? Many thanks.
Sample Data
However, I really need to only lookup the values relating to 'Current Week' field in the 'Lookup Data' dataset. Can you please advise the best formula to do this please? Many thanks.
Sample Data
First recommendation is to not use LOOKUP formula for this situation. Bring both tables and create a relationship with them through the EventKey column. Once you have your relationship, you can easily select only data for Current Week by using the Filters Pane or a Slicer Visual.
1 Reply
- ray_aramburo
Super User
First recommendation is to not use LOOKUP formula for this situation. Bring both tables and create a relationship with them through the EventKey column. Once you have your relationship, you can easily select only data for Current Week by using the Filters Pane or a Slicer Visual.