Forum Discussion

Michael1's avatar
Michael1
Icon for Advocate II rankAdvocate II
9 years ago
Solved

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, isLastEntryfor...
Need Help
Tutorial Requests
  • Michael1's avatar
    Michael1
    9 years ago

    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's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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