Forum Discussion
How to remove duplicates in calculated column?
Hi Zain26,
Create measures like below:
Max Count = CALCULATE ( MAX ( 'TimeRange Table'[CountofTimeRange] ), ALLEXCEPT ( 'TimeRange Table', 'TimeRange Table'[USER] ) ) Peak Time Range = CALCULATE ( LASTNONBLANK ( 'TimeRange Table'[TimeRange], 1 ), FILTER ( 'TimeRange Table', 'TimeRange Table'[CountofTimeRange] = [Max Count] ) )
Add field [USER] into Columns area of matrix, and add measure [Peak Time Range] into Values section.
Best regards,
Yuliana Gu
Hi,
I think i have solved it. See the image below. Is that the result you are expecting?
You posted a similar question here. Now please tell me which of the two questions is your actual one - the one in this thread or the other one. The major difference between both datasets is that the one in the other link does not have any count column (you have inface created that in a calculated column). So, my question is that in your base data, will you actually have a count column or no.
I have also been able to solve the probelm where you do not have a count column. See imag below
- Hi Ashish, yes you have solved it. The actual data doesn't have a count column, I have created a calculated column to get the count. Please share the formula with which you solved this.
Hi,
Please give me time until tomorrow to share my solution.