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
Hello EaglesTony ,
Let's make it more clear. You have now 2 tables
1. Final Table with columns Key ,Date and Cycle
2. ReportTable with Key and other columns
3. A mesure for Cycle
You want to show values from FinalTable and ReportTable and Cycle as a slicer.
Have you checked if there is relationship setup between FinalTable and ReportTable ? If not, create a relationship on Key and try again.
I am able to use cycle as slicer to show values from both the tables (kindly ignore blank value , this is for testing only).
I hope this helps.
What i have is:
1) FinalTable with Key and Cycle
2) ReportTable that has Key and Cycle (based off a lookup to FinalTable)
3) Slicer that is using a Cycle field from a Cycle table
What I am trying to do is build a relationship between Cycle of the ReportTable to Cycle of the Cycle table, and have it as "Both", so that when the Slicer changes(Say Cycle 2), it will show all those records in ReportTable that have Cycle 2.
However when trying to establish this relationship it is giving me a circular reference.