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)

quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi DavidB023

 

I think the simplest thing to do is to create a new measure

 

Last_Month = MAX(YourTable[Date].[Month])

 

 

- Quentin