Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
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?
@DavidB023 I didn't understand what you want, but have you tried to use the function LASTDATE()?
@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)
Hi @DavidB023
I think the simplest thing to do is to create a new measure
Last_Month = MAX(YourTable[Date].[Month])
- Quentin
@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.
You should just be able to use MAX.
@quentin_vigne@Anonymous@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..
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |