Data Aproximada (Date Nearby)

Question

Hello people,&nbsp;I have the follow situation:Table1:BANK A - 02/01/2019 - 150,00BANK B - 02/01/2019 - 10.000,00BANK A - 04/01/2019 - 300,00BANK C - 05/01/2019 - 500,00BANK A - 09/01/2019 - 400,00&nbsp;Table2:BANK A - 02/01/2019BANK A - 03/01/2019BANK A - 04/01/2019BANK A - 05/01/2019BANK A - 06/01/2019BANK A - 07/01/2019BANK A - 08/01/2019BANK A - 09/01/2019BANK B - 02/01/2019BANK B - 03/01/2019BANK B - 04/01/2019BANK B - 05/01/2019BANK B - 06/01/2019BANK B - 07/01/2019BANK B - 08/01/2019BANK B - 09/01/2019BANK C - 02/01/2019BANK C - 03/01/2019BANK C - 04/01/2019BANK C - 05/01/2019BANK C - 06/01/2019BANK C - 07/01/2019BANK B - 08/01/2019BANK C - 09/01/2019&nbsp;And i need the follow Result in table 2:&nbsp;BANK A - 02/01/2019 - 150,00BANK A - 03/01/2019 - 150,00BANK A - 04/01/2019 - 300,00BANK A - 05/01/2019 - 300,00BANK A - 06/01/2019 - 300,00BANK A - 07/01/2019 - 300,00BANK A - 08/01/2019 - 300,00BANK A - 09/01/2019 - 400,00BANK B - 02/01/2019 - 10.000,00BANK B - 03/01/2019&nbsp;- 10.000,00BANK B - 04/01/2019&nbsp;- 10.000,00BANK B - 05/01/2019&nbsp;- 10.000,00BANK B - 06/01/2019&nbsp;- 10.000,00BANK B - 07/01/2019&nbsp;- 10.000,00BANK B - 08/01/2019&nbsp;- 10.000,00BANK B - 09/01/2019&nbsp;- 10.000,00BANK C - 02/01/2019 - 0,00BANK C - 03/01/2019 - 0,00BANK C - 04/01/2019 - 0,00BANK C - 05/01/2019 - 500,00BANK C - 06/01/2019 - 500,00BANK C - 07/01/2019 - 500,00BANK B - 08/01/2019 - 500,00BANK C - 09/01/2019 - 500,00&nbsp;The result i need is similar a Excel vlookup with relative reference - vlookup(value,range,index, -1)&nbsp;I will be gratefull for any help.&nbsp;&nbsp;

amitchandak · Accepted Answer

I created two columns in table 2Refer : https://www.dropbox.com/s/w3zitr1waygzqbf/approxAmount.pbix?dl=0&nbsp;Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blog -Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trendPower-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-RangesConnect on Linkedin

Forum Discussion

Data Aproximada (Date Nearby)

2 Replies

Related content

Date hierarchy

Búsquedas aproximadas condicionales

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

Filtercontext with date relation

Between date filter with fixed start date and latest end date