How to use a date from another table ?

Question

Hi,&nbsp;&nbsp; I have the following table&nbsp;Item&nbsp; &nbsp; &nbsp;Complete Date1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/2/20252&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/2/20253&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/15/20254&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3/29/20255&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4/3/20256&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6/1/2025&nbsp;I have another table withQuarter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Start Date&nbsp; &nbsp; End DateQ1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/8/2025&nbsp; &nbsp; &nbsp;4/1/2025Q2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4/2/2025&nbsp; &nbsp; &nbsp; 7/8/2025&nbsp;What I need is a new columnItem&nbsp; &nbsp; &nbsp;Complete Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Quarter1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/2/2025&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; null2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/2/2025&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; null3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/15/2025&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3/29/2025&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4/3/2025&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6/1/2025

nilendrafabric · Answer

Try this&nbsp;&nbsp;Quarter =CALCULATE(MAX('Quarters'[Quarter]),FILTER('Quarters',Items[Complete Date] &gt;= 'Quarters'[Start Date] &amp;&amp;Items[Complete Date] &lt;= 'Quarters'[End Date]))

ashish_mathur · Answer

Hi,
Write this calculated column formula in Table1
Quarter = calculate(max('Table2'[Quarter]),filter('Table2','Table2'[Start Date]&lt;=earlier('Table1'[Complete date])&amp;&amp;'Table2'[End Date]&gt;=earlier('Table1'[Complete date])))
Hope this helps.

Forum Discussion

How to use a date from another table ?

2 Replies

Related content

Find Most Recent Date Relative to another Date Column in Power Query

Filtering Dates from another table

Date Slicer not Responsive to Calculated Date Table

Conditional format date based on another date

If date is greater than another date in another table