Forum Discussion
Showing the latest value
Hi All, I have a table that looks like the following; Date Total Amount Owed 01/01/2020 £1,000.00 01/02/2020 £2,000.00 01/03/2020 £8,000.00 01/04/2020 £6,000.00 01/05/2020...
Anonymous , try lastnonblankvalue
lastnonblankvalue(Table[Date], max(Table[Total Amount Owed]))
https://docs.microsoft.com/en-us/dax/lastnonblankvalue-function-dax
mahoneypat
Microsoft Employee
Microsoft EmployeeYou can use a measure like this to get the latest value
Latest Amt Owed =
VAR latestdate =
MAX ( Table[Date] )
RETURN
CALCULATE ( MAX ( Table[Total Amount Owed] ), Table[Date] = latestdate )
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat