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.

     

Anonymous's avatar
Anonymous
Not applicable
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.