Forum Discussion
Get last text value by date
I have a very simple problem, but it seems like all the answers so far on the forums are very complicated. I wanted to make the code as simple as possible. Basically, I have a table of two colum...
Anonymous - You basically want Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
Basically,
Measure = VAR __maxDate = MAXX(ALL('Table'[Date]),[Date]) RETURN MAXX(FILTER('Table',[Date]=__maxDate),[truefalse])
amitchandak
Super User
Super UserAnonymous , plot this measure with date
lastnonblankvalue(table[timestamp], max(Table[Value]))
Date = [timestamp].date