Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

last status

hello, i have a data set of custumers status en date and i only want to show the last status of thath customer for example: customer A      status open             date 1-1-2020 customer C    ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous 

    Create a measure like :

    latest_status = 
var _maxdate=MAX('Table'[date])
return CALCULATE(SELECTEDVALUE('Table'[status]),ALLEXCEPT('Table','Table'[customer]),'Table'[date]=_maxdate)

    Then you will get a result like below :

    When you add new row for A and the status is open , then you will get a result like this :

    I have attached my pbix file , you can refer to it .

     

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

Hi Anonymous 

 

there are multiple ways to do so, you may create a column with such code:

LatestStatus =
VAR CurrentCustomer = Customer[customer]
VAR MaxDate =
MAXX(
    FILTER(Customer, Customer[customer]=CurrentCustomer),
    Customer[Date]
)
RETURN
CALCULATETABLE(
    VALUES(Customer[status]),
    Customer[customer] = CurrentCustomer,
    Customer[Date] = MaxDate,
    ALL()
)

I tried and it worked like this:

in Table Visual: