Connection between different dates

[pbi_rafal]

Hi,

I have two data sets, where the main one is refreshed every day and the 2nd one is based on the user's ad hoc intervention. To connect two data sets together I've created Reporting_Date table with distinct reporting_dates. Now I would like to create Manual_Date column where I assigned for each reporting date relavant manual input date. Can you help me with the DAX formula to receive Manual_Date column? Manual Input date should be equal or higher than Reporting_Date but also we should take into account that we need to take the most recent one (if exist)

Thanks

[pbi_rafal]

Brilliant solution! Thanks Miguel!

[MFelix · Accepted solution]

Hi @pbi_rafal ,

From what I can understand the first two table are is your initial input try the following steps:

Power query:

1. Do a new table with a merge of both table by date
2. Expand the column Manual Input
3. Fill down

1.

2.

3.