Forum Discussion
How do I get a value from another table based on a date range
Hello EaglesTony ,
Simple use Lookup between FinalTable and ReportTable to get the value :
Cycle =LOOKUPVALUE(FinalTable [Cycle], -- Column to returnFinalTable [Key], ReportTable [Key] -- Matching Key from both tables)I have checked this with sample data :I hope this is what you are looking for .
Did I solve your Query ? Please mark this as solution. Appreciate Kudos always
Cheers
I'm able to get the correct cycle on this table.(call it FinalTable)
My issue now is there is a 3rd table (ReportTable), which I need to get this field into, but the issue is that the 3rd table has Keys that some don't match the FinalTable.
Thanks for confirming first one is completed. Can you please add sample data for 3rd table ?
FinalTable has:
Key Column1 Column2 Cycle
1 John Doe 2
3 Jane Doe null
ReportTable has
Key Column1a Column2a
1 John Doe
5 Alex Doe
I'd like to have ReportTable as
Key Column1a Column2a Cycle
1 John Doe 2
5 Alex Doe null
Hello EaglesTony ,
Simple use Lookup between FinalTable and ReportTable to get the value :
Cycle =LOOKUPVALUE(FinalTable [Cycle], -- Column to returnFinalTable [Key], ReportTable [Key] -- Matching Key from both tables)I have checked this with sample data :I hope this is what you are looking for .
Did I solve your Query ? Please mark this as solution. Appreciate Kudos always
Cheers
I assume this is a measure on the ReportTable ?