Lastnonblank not returning correct results

I'm trying to return the last non-blank row of the "Target stage outcome" column based on the "Entity" column.  However, using the lastnonblank dax formula is not yielding the correct results. 

I have attached the example fact table below. 

Here is the results that I'm trying to get are those in the red box:

I've created a summary table to see the results

Despite the "Index" and "Last day" returning the correct results, the "Stage" field is not returning the correct result. 

This is the "Target" table that I'm using in my summary table above

I would appreciate if someone could help me here. 

Thanks