how to find min and max of time in timestamp column when there are different dates

[Anonymous]

Hi,

Need a help with this.

Any help would be appreciated.

I have start and end date column and corresponding to that activity name and operation column.

there are one week data as date starts from 14 to 21 and corresponding tot aht there are almost 15 different operation assigned to each date and 30 activity names are there.

In start and end date column ,i want min of start date (minumum time) and maximun time of end date when the activity is sg1005 and operation is ABC1 for date 14,date 15,....date 21.when operation name change to abc2,i want start date minimun and end date minimun for date 14 to 21.same way it ll give for operation and all activity when activityname ll change from  sg1005 to any other(as there are 30 activity.)

Can i do this thing in power bi?

Thanks in advance.

[amitchandak · Accepted solution]

Refer

https://community.powerbi.com/t5/Desktop/highest-value-by-category/td-p/428758

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601