Forum Discussion
Solved
consolidating rows
Hello community, I have a senario like this
and i am trying to consolidate the date in the following format
Thanks.
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.
1 Reply
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.