consolidating rows

[jaipal]

Hello community, I have a senario like this

 and i am trying to consolidate the date in the following format

Thanks.

[Anonymous · Accepted solution]

Hi @jaipal ,

Change the time format.

Create three measures.

Max_date = CALCULATE(MAX('Table'[End time]),FILTER(ALL('Table'),'Table'[Employee name]=SELECTEDVALUE('Table'[Employee name])&&'Table'[Date]=SELECTEDVALUE('Table'[Date])))

Min_date = CALCULATE(MIN('Table'[Start time]),FILTER(ALL('Table'),'Table'[Date]=SELECTEDVALUE('Table'[Date])&&'Table'[Employee name]=SELECTEDVALUE('Table'[Employee name])))

Duration_time = CALCULATE(SUM('Table'[Duration]),FILTER(ALL('Table'),'Table'[Employee name]=SELECTEDVALUE('Table'[Employee name])&&'Table'[Date]=SELECTEDVALUE('Table'[Date])))

Best Regards

Community Support Team _ polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.