Forum Discussion
Finding the most recent value change
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
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
3 Replies
- Greg_DecklerCommunity Champion
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.
- v-ljerr-msftMicrosoft Employee
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? :smileyhappy:
Regards
- Michael1Advocate II
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