Closest future date in another table

[tryingnewtools]

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

[tryingnewtools · Accepted solution]

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...