Forum Discussion
Closest future date in another table
Hi,
I am am trying to get the closest future date from one table, based on the dates in another table.
I have 2 tables:
Prices: which has a continuous list of dates
Fundamentals: which has a list of dates by quarter
What calculation can I do to return the closest future quarter, based on the date in the price table (i.e., the row with "2/1/2000" in the price table, should return (3/31/2000) from the fundamental table
Thank you
Got it to work by creating a unique quarter identifier for each table.
Then used LOOKUPVALUE('Fundamental'[Quarter], 'Fundamental'[Quarter Identifer], 'Prices'[Quarter Identifier])
Probably not the greatest solution...but works...
1 Reply
- tryingnewtoolsRegular Visitor
Got it to work by creating a unique quarter identifier for each table.
Then used LOOKUPVALUE('Fundamental'[Quarter], 'Fundamental'[Quarter Identifer], 'Prices'[Quarter Identifier])
Probably not the greatest solution...but works...