how to show min and max values between start and end time in table

[balarajua]

Hi All,

I have to show the min and max value of downtime of websites with start and end time in below table format

Data:

Website	Starttime	Endtime	Downtime_in_minutes
https://abc1.com	3/15/21 18:57: 00 PM	3/16/21 5:32:00 AM	635
https://abc.com	3/15/21 18:57:00 PM	3/16/21 5:32:00 AM	63
https://abc2.com	3/15/21 18:57:00 PM	3/16/21 5:32:00 AM	64
https://abc.com	3/14/21 18:57:00 PM	3/15/21 5:32:00 AM	14
https://abc1.com	3/13/21 18:57:00 PM	3/14/21 5:32:00 AM	6

 Expected Result:

Type	Starttime	Endtime	DowTime
Minimum	3/13/2021 18:57	3/14/2021 5:32:00	6
Maximum	3/15/21 18:57: 00 PM	3/16/2021 5:32:00	635

[Taoufiq_Zarra]

@balarajualike

Dimension :

=Valuelist('Minimum','Maximum')

Measures:

Starttime->

Pick(Match(Valuelist('Minimum','Maximum'),'Minimum','Maximum'),
FirstSortedValue(Starttime,Downtime_in_minutes),
FirstSortedValue(Starttime,-Downtime_in_minutes))

Endtime->

Pick(Match(Valuelist('Minimum','Maximum'),'Minimum','Maximum'),
FirstSortedValue(Endtime,Downtime_in_minutes),
FirstSortedValue(Endtime,-Downtime_in_minutes))

DowTime->

Pick(Match(Valuelist('Minimum','Maximum'),'Minimum','Maximum'),
min(Downtime_in_minutes),
max(Downtime_in_minutes))

output :