Forum Discussion

tryingnewtools's avatar
tryingnewtools
Regular Visitor
8 years ago
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

 

 

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

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