Forum Discussion
Boycie92
Resolver I
Resolver ISecond Last Date Total
Hi, I am hoping someone can help I have a very simple table. I would like to be able to create a measure that would provide the figure (total) for the second last date available in my data. S...
measure =
var _max= maxx(allselected(Table),Table[date])
return
calculate(lastnonblankvalue(Table[date],Sum(Table[Total])),Table[Date]<_max)OR
measure =
var _max= maxx(allselected(Table),Table[date])
return
calculate(lastnonblankvalue(Table[date],Sum(Table[Total])),filter(allselected(Table),Table[Date]<_max))
Boycie92Resolver I
Resolver IHi amitchandak
That works perfectly thank yo so much. Is there anyway to display the second las date as a seperate messure?
Thanks,
Boycie92
amitchandak
Super User
Super UserBoycie92 , Create a measure in the same way as the last one and in that use
max(Table[Date]) in place of Sum(Table[Total])