Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
9 years ago
Solved

Show Most Recent Date

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 ...
Need Help
  • BetterCallFrank's avatar
    BetterCallFrank
    9 years ago

    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

kiwidoc's avatar
kiwidoc
New Member
4 years ago

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