Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
Could you help me, please?!
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"
Solved! Go to Solution.
@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])
@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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |