Forum Discussion
Problem finding just the latest value in a column
Clint ,
lastnonblankvalue(Table[Date],sum(Table([ABD])))
lastnonblankvalue(Table[Date],Max(Table([ABD])))
refer : https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
4 Replies
Clint ,
lastnonblankvalue(Table[Date],sum(Table([ABD])))
lastnonblankvalue(Table[Date],Max(Table([ABD])))
refer : https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
Thank you Amit. The first DAX expression did the trick. I had tried something like that before but didn't add the "date" part of lastnonblankvalue so thank you.
A few ways you can do this. Here are two. Both assume you have the ID column in your visual (so additional filtering for that is not needed in these measures).
1. Last Value = LASTNONBLANKVALUE(Table[Date], MIN(Table[ABD]))
2. (Replace Value with ABD and Last with your actual table name)
Last Value =
VAR maxdatewithvalue =
MAXX (
FILTER ( SUMMARIZE ( Last, Last[Date], Last[Value] ), Last[Value] > 0 ),
Last[Date]
)
RETURN
CALCULATE ( MIN ( Last[Value] ), Last[Date] = maxdatewithvalue )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
