Forum Discussion
lcasey
Post Prodigy
Post ProdigyGet 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...
amitchandak
Super User
Super User@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))