Forum Discussion
Solved
Last date value
Hi everybody ! I want to show a last date value without a slicer, so I try function like firstnonblank and lastnonblank but nothing worked.. Is it possible or should I put a date slicer in order...
That is why it is important to post sample data to clarify. Try this:
Measure = VAR maxDate = MAX('Table'[Date]) RETURN MAXX(FILTER('Table',[Date]=maxDate),[Column])Something like that.
Anonymous
I would like to display a value which correspond to my last date value. So for exemple, my date are in month, today I want to see May value. (all of this without a slicer to choose date)
You should just be able to use MAX.
quentin_vigneAnonymousGreg_Deckler thanks for your answer !
In fact it concern squad data, so it would be easy like MAX if my enterprise just hire month after month ^^ but it is like :may 2018 500
avril 2018 450
march 2018 503So, today I want to display 500 on my repport..
That is why it is important to post sample data to clarify. Try this:
Measure = VAR maxDate = MAX('Table'[Date]) RETURN MAXX(FILTER('Table',[Date]=maxDate),[Column])Something like that.