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 to forecast a last date value ?

 

Thanks

Best regards

David

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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    DavidB023 I didn't understand what you want, but have you tried to use the function LASTDATE()?

    • 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)

  • YeldarR's avatar
    YeldarR
    Frequent Visitor
    4 years ago

    Hello.

    Yes, that formula works for 1 level items. But when I add the one level above which is supposed to summarize the calculated level 1 numbers, it works exactly the same as level 1. It doesn't add but returns 1 biggest value. Can you solve that?