Fulfill missing months

[angel0v89]

Hi all, 

I was reading some of the articles already and still can't find a resolution to my query. I hope someone can help. 

The data I have got is: 

Client Name	Start Date	End Date	Amount
Alex Ltd	2020-09-07	2021-09-06	16000
Alex Ltd	2020-11-30	2021-11-29	15000
Alex Ltd	2021-01-29	2021-04-28	20000

What I would like to do, is to fulfill the missing months between the start dates with the amount from the previous row.

Client Name	Date	Amount
Alex Ltd	Sep-2020	16000
Alex Ltd	Oct-2020	16000
Alex Ltd	Nov-2020	15000
Alex Ltd	Dec-2020	15000
Alex Ltd	Jan-2021	20000
Alex Ltd	Feb-2021	20000
Alex Ltd	Mar-2021	20000
Alex Ltd	Apr-2021	20000
Alex Ltd	May-2021	0
Alex Ltd	June-2021	0
Alex Ltd	July-2021	0
Alex Ltd	Aug-2021	0

And the data to finish up to the previous month we are currently at. 

Can anyone help please?

Alex

[atcodedog05]

_

[atcodedog05]

Hi @angel0v89 

I was able to arrive at the expected output. Considering everything after max end date is 0.

Workflow:

Hope this helps : )

[Luke_C]

Hi @angel0v89 

Here's my take on this:

(edited to get april value)

[atcodedog05]

Really interesting take on the usecase @Luke_C 🙂👍

[angel0v89]

Hi there, 

Thank you so much for the output! When I ran the latest version I still have values after the April, for that one, I would like to have values =0 until the end of the contract (End Date). Exactly as in your latest screenshot

[atcodedog05]

Hi @angel0v89 

Must be a bug. Reuploaded it can you check now 🙂

[angel0v89]

Thank you very much folks! Much appreciated! 

[atcodedog05]

Happy to help : ) @angel0v89 

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!