Hello, hope you’re doing well.
I have two tables that I’m trying to bring the following result.
Table 1 - Dates and Values
Table 2 - Dates and currency amount
I’ve used “joiner” with the dates criteria but the problem is that the currency value does not appear dates every 10 days.
To be clear of what I’m looking for is that the last currency value showing, repeats until the next one that already exists and then repeats the cycle again. The image below shows exactly the wanted outcome.
Thanks!