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

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Boycie92 , Create a measure in the same way as the last one and  in that use

      max(Table[Date]) in place of Sum(Table[Total])