Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

When duplicaets keep value with most recent date

Hello everyone,

 

I had to find the most recent Status Date for each project, but for some project i have multiple results (usually 2) and don't understand how for some it works but for others doesn't.

 

My solution to find the most recent Status is the following :

So Most Recent Date is the filter I use so it could only give me the first (1) most recent result.
What am I missing ?

 

Thanks in advance !

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Create measures like this 

     

    Measure =
    VAR __id = MAX ('Table'[ID] )
    VAR __date = CALCULATE ( MAX('Table'[DAte] ), ALLSELECTED ('Table' ), 'Table'[ID] = __id )
    CALCULATE ( MAX ('Table'[Status] ), VALUES ('Table'[ID] ),'Table'[ID] = __id,'Table'[DAte] = __date )