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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

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.