cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper III

## Most recent status

Hi Guys,

As you can see, the measure below returns me the status of the ID with the most recent date, but I came across this situation where I have two equal dates. What could I do in this case considering also the most recent date and the most recent status which is "Pós Reunião - Follow Up"

1 ACCEPTED SOLUTION
Super User

@karinafreitass , Not very clear with you screen shot, You can get latest status using a measure like

Measure =
VAR __id = MAX ('Table'[ID] )
VAR __date = CALCULATE ( MAX('Table'[NUM] ), ALLSELECTED ('Table' ), 'Table'[ID] = __id )

return
CALCULATE ( MAX ('Table'[Status] ), VALUES ('Table'[ID] ),'Table'[ID] = __id,'Table'[NUM] = __date )

or a new column

Measure =
VAR _date = MAXX(Filter(Table, [ID] = earlier([ID])), [Date])
return
MAXX(Filter(Table, [ID] = earlier([ID]) && [Date] =_date), [status])

2 REPLIES 2
Super User

@karinafreitass , Not very clear with you screen shot, You can get latest status using a measure like

Measure =
VAR __id = MAX ('Table'[ID] )
VAR __date = CALCULATE ( MAX('Table'[NUM] ), ALLSELECTED ('Table' ), 'Table'[ID] = __id )

return
CALCULATE ( MAX ('Table'[Status] ), VALUES ('Table'[ID] ),'Table'[ID] = __id,'Table'[NUM] = __date )

or a new column

Measure =
VAR _date = MAXX(Filter(Table, [ID] = earlier([ID])), [Date])
return
MAXX(Filter(Table, [ID] = earlier([ID]) && [Date] =_date), [status])

Helper III

@amitchandak Thank you so much

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors