Forum Discussion
Solved
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 Fundament...
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...
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...