Only show latest project

[Rebecca]

Hello Community,

I need your help with the following topic. 
I have an excel table with the columns below: 

project / status / date 

For each project it is possible to change the status more then once a month. 
At the end of each month I want to know the latest project status of the month. (E.g. at the 01.02 project status was 'nok' but it changed on 20.02 to 'ok') 
If I use the count function in the table chart I can see both project status in February. Instead I only want to see the 'ok' status. 

Have you any advice how to handle? 

Thanks in advance! 
Rebecca

[JordyWegman · Accepted solution]

Hi Rebecca,

Try to use the Max(Date) with your status dimension. I can't imagine that these kind of statuses change on the same day right? 

Using the max date will give you the last status of that project.

Jordy

Climber