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])
Greg_Deckler
Community Champion
Community ChampionAnonymous - 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])Thanks! it worked great. I just changed the "ALL" to "ALLSELECTED" for filtering purposes.