Forum Discussion
Get specific column from Last record
Hello, I have a table that I would like to find the last record and specifically show the "Closed Month" Field. The measure should only display the word Oct-2021 because that is the last record...
is your [Closed Month] field a text field or a Date field? It needs to be a Date field if you want the logic to work - you can still format it in the way you need.
The [Date Key] field is equally suspicious. Use actual numbers like 202001 instead of text "2020-1".
Its a text field. I ended up using a table as the slicer so I can show the months that are closed:
