Value for maxdate

[daliux]

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 be like this: in 1 case it should be 'pau', in 2 case - 'pau' too. Could someone help me, please?

[Anonymous · Accepted solution]

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.

[amitchandak]

@daliux , You can create status measure like

Measure =
VAR __id = MAX ('Table'[id] )
VAR __Version_Id = CALCULATE ( MAX('Table'[Logged_at] ), ALLSELECTED ('Table' ), 'Table'[id] = __id )
RETURN CALCULATE ( MAX ('Table'[Status] ), VALUES ('Table'[id] ),'Table'[id] = __id,'Table'[Logged_at] = __Version_Id )

and use that in visual