Forum Discussion

lcasey's avatar
lcasey
Post Prodigy
5 years ago

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...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi lcasey ,

 

According to your needs, you want to get the latest records based on the "Yes" in the Closed column. I did the following test: note that ALLSELECT function keeps the slicer external filter and the created measure is added to the Card to return the latest record under “Yes”.

 

Best Regards,
Henry

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.