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
amitchandak's avatar
amitchandak
Super User
5 years ago

@lcasey, Test as

Medidas ?
var _max - MAXX(filter(Allselected(FY),FY[Closed] á "Yes"), FY[DateKey])
devolución
CALCULATE(MAX(FY[Closed Month]),Filter(Allselected(FY), FY[Closed] á "Yes" && [DateKey] á _max))

O


Medidas ?
var _max - MAXX(filter(all(FY),FY[Closed] á "Yes"), FY[DateKey])
devolución
CALCULATE(MAX(FY[Closed Month]),Filter(all(FY), FY[Closed] á "Yes" && [DateKey] á _max))