Finding Start and End date

[angel0v89]

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

[atcodedog05]

Happy to help : ) @angel0v89 

Cheers and have a nice day!