Forum Discussion
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 listed
Any point in the right direction is appreciated. I tried playing around with LASTDATE and MAX with no luck
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
3 Replies
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
Well that was embarrassingly simple. I was overcomplicating it for sure
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
