Create column with actual status

[Anonymous]

Hi everyone

I have a problem and I can not solve it.
I have a table like this:

I need to build a column calculated with the actual status, like this:

I am trying but probably I am doing something wrong.

Does someone help me?

[Vera_33 · Accepted solution]

Hi @Anonymous 

You want a Column in DAX or M? It's one in DAX

Actual = 
VAR CurP = yourTable[Product]
VAR MaxDate = MAXX(FILTER(yourTable,yourTable[Product]=CurP),[Date])
RETURN
MAXX(FILTER(ALLEXCEPT(yourTable,yourTable[Product]),yourTable[Date]=MaxDate),yourTable[Status])