Hi all,
I have got a use case that I really need help!
I have got the following dataset which is on a monthly basis, for example 1 row per company per month.
| Date | Id | Company Name | Value |
| 01-03-2019 | 12345 | Dan Ltd | 2000 |
| 01-04-2019 | 12345 | Dan Ltd | 5000 |
| 01-05-2019 | 12345 | Dan Ltd | 10000 |
| 01-01-2019 | 67886 | Alex Ltd | 5000 |
| 01-02-2019 | 67886 | Alex Ltd | 0 |
...and so on.
So the idea is to create a Start date and End Date for each client based on the value. When the first value>0 exist to capture the Date as a start date and when it goes to zero to be end date.
From the above case:
Dan Ltd - Start Date - 01-03-2019
Dan Ltd - End Date - (empty, since it is still current client)
Alex Ltd - Start Date - 01-01-2019
Alex Ltd - End Date - 01-02-2019
Many thanks in advance
