Need help on Qlik Sense Transformation from below given input

[vish123]

Hi Team,

I have input like below.

Metric	Target	Description	Date
M1	95	T2 95% in 8 Hours	1.2022
M1	95	T2 95% in 8 Hours	2.2022
M1	100	T2 100% in 8 Hours	3.2022
M1	100	T2 100% in 8 Hours	4.2022
M1	90	T2 90% in 8 Hours	5.2022

Output should like this: 

Metric	Target	Description	From Date	To Date
M1	95	T2 95% in 8 Hours	1.2022	2.2022
M1	100	T2 100% in 8 Hours	3.2022	4.2022
M1	90	T2 90% in 8 Hours	5.2022	null

Can you please suggest/help on how can i transform data input into output as shown above..

[maxgro · Accepted solution]

The OUPTPUT table has 

3 dimensions

and 2 expressions

Date(Min(Date#(Date, 'M.YYYY')), 'M.YYYY')

IF(COUNT(Date)=1, NULL(), Date(Max(Date#(Date, 'M.YYYY')), 'M.YYYY') )

[vish123]

Hi Maxgro,

Wonderful, thanks a lot for your help:)