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