Show Most Recent Date

[bhmiller89]

I have a columns: Organization |NoteDate|Note

I need to write a measure that will display the most recent NoteDate for each Organization.  Each Organization has thousands upon thousands of notes listed 

Any point in the right direction is appreciated. I tried playing around with LASTDATE and MAX with no luck

[kiwidoc]

Thanks for that, I had the same issue.

I'm a bit of a newbie.

When I then go to put in the value of last record it still displays all records. I want to see only the most recent result.

Below is the column witht he most recent date (First column is a patient identifier its in half. Its not identifiable but best keep these things safe!) Next it is what happens when I grag the measure I'm interested in to the visualisation. Lots of records and not showing just the most recent

Most recent no valuesMost recent with values

[BetterCallFrank · Accepted solution]

1) create a measure MaxNoteDate = Max( Table[NoteDate] ) (or select default summarization = "MAX" for this column or select it in the visual)

2) create a table visualisation and put Organization on columns

3) put measure from 1) on the visual

that should be it...?

what's the problem with what you've got so far? can you show us some screenshots with your hurdles?

HTH,

Frank

[bhmiller89]

Well that was embarrassingly simple.  I was overcomplicating it for sure