Finding the most recent value change

[Michael1]

Hello BI Community:

I am trying to create a calculated column that indicates if data for each school is the most recent based on a completion time.

The current column, isLastEntryforDay is calculated with this code:

isLastEntryforDay = 
	if((TenDayCount[Completion time])=MAXX(
		FILTER(
			TenDayCount,
			TenDayCount[School]=EARLIER(TenDayCount[School])
		),
		TenDayCount[Completion time]),
	true(),
	false()
	)

However, I really want it to return true if it is the last entry based on the Day column.  Not overall. 

I would be grateful if anyone could help me modify the DAX (or provide an alternative solution) to accomplish this.

Thank you,

Michael

[Michael1 · Accepted solution]

The solution I used to solve this was to create a new custom column

= Table.AddColumn(#"Replaced Errors", "SchoolDay", each [Day]&","&[Code])

Then, I used the same code as before to determine the most recent entry.

Michael

[v-ljerr-msft]

Hi @Michael1,

---

---

However, I really want it to return true if it is the last entry based on the Day column.  Not overall. 

I'm not sure I understand your requirement totally. Could you be more precisely with it by posting your expected result against the sample data you posted above? 

Regards

[Greg_Deckler]

So, regardless of month and year, if it is the highest day number? So, Jan 30th, 1956 would be the last day versus Dec 29, 2017?

Apologies if I am not understanding something.