cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidB023 Member
Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Last date value

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


7 REPLIES 7
HarrisonCbe Member
Member

Re: Last date value

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

DavidB023 Member
Member

Re: Last date value

@HarrisonCbe

 

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)

Super User
Super User

Re: Last date value

You should just be able to use MAX.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


HarrisonCbe Member
Member

Re: Last date value

@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.

quentin_vigne Senior Member
Senior Member

Re: Last date value

Hi @DavidB023

 

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

 

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

 

 

- Quentin

DavidB023 Member
Member

Re: Last date value

@quentin_vigne@HarrisonCbe@Greg_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..

Highlighted
Super User
Super User

Re: Last date value

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 40 members 805 guests
Please welcome our newest community members: