Forum Discussion
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...
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?