Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago
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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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.

DavidB023's avatar
DavidB023
Helper III
8 years ago

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             503

 

So, today I want to display 500 on my repport..

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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.