Forum Discussion

Boycie92's avatar
Boycie92
Resolver I
6 years ago
Solved

Second 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...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Boycie92 

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

amitchandak's avatar
amitchandak
Super User
6 years ago

Boycie92 

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

Boycie92's avatar
Boycie92
Resolver I
6 years ago

Hi amitchandak 

 

That works perfectly thank yo so much. Is there anyway to display the second las date as a seperate messure?

 

Thanks,

Boycie92