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

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)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

DavidB023 ok, maybe try = FORMAT(LASTDATE(TableName[Date].[Date]),"MMMM"), this formula returns the name of the month of the last date of the "Date" column you have.