Forum Discussion

daliux's avatar
daliux
Frequent Visitor
4 years ago
Solved

Value for maxdate

Hello. I have items with dates of status change. I need a column for last status of selected period. I need dax formula for a values of staus on max logged_at date  for each item (id). Result sould ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi daliux 

    I created a sample with the data you provided .

    Create a measure to return the Status with latest date .

     

    Measure =
VAR _maxdate=CALCULATE(MAX('Table'[logged_at]),ALLEXCEPT('Table','Table'[Id]))
var _status=CALCULATE(MAX('Table'[Status]),FILTER('Table','Table'[Id]=MAX('Table'[Id]) && 'Table'[logged_at]=_maxdate))
return _status

     

    Then put the measure in your table visual , you will get a result like below .

    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
4 years ago

Hi daliux 

I created a sample with the data you provided .

Create a measure to return the Status with latest date .

 

Measure =
VAR _maxdate=CALCULATE(MAX('Table'[logged_at]),ALLEXCEPT('Table','Table'[Id]))
var _status=CALCULATE(MAX('Table'[Status]),FILTER('Table','Table'[Id]=MAX('Table'[Id]) && 'Table'[logged_at]=_maxdate))
return _status

 

Then put the measure in your table visual , you will get a result like below .

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.