topic Re: Value for maxdate in DAX Commands and Tips

Value for maxdate

daliux — Thu, 31 Mar 2022 11:41:59 GMT

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?

Re: Value for maxdate

amitchandak — Thu, 31 Mar 2022 13:36:28 GMT

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

Re: Value for maxdate

Anonymous — Wed, 06 Apr 2022 05:21:06 GMT

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.