Forum Discussion

Clint's avatar
Clint
Helper V
5 years ago
Solved

Finding the right value using Lastnonblank

Just when I thought I was getting a handle on LastNonBlank, I'm not    Per the embedded table below, shouldn't this DAX return the highlighted value and not the one above it? Latest Comment =...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Clint , Try like

     

    lastnonblankvalue(Table[Week],max(Table[Comment]))

    or

    calculate(lastnonblankvalue(Table[Week],max(Table[Comment])), allexcept(Table, Table[project]))

    or

    calculate(lastnonblankvalue(Table[Week],max(Table[Comment])), filter(allselcted(Table), Table[project]=max( Table[project])))

amitchandak's avatar
amitchandak
Super User
5 years ago

Clint , Try like

 

lastnonblankvalue(Table[Week],max(Table[Comment]))

or

calculate(lastnonblankvalue(Table[Week],max(Table[Comment])), allexcept(Table, Table[project]))

or

calculate(lastnonblankvalue(Table[Week],max(Table[Comment])), filter(allselcted(Table), Table[project]=max( Table[project])))

Clint's avatar
Clint
Helper V
5 years ago

amitchandak ,

 

Thanks Amit.  This worked: lastnonblankvalue(Table[Week],max(Table[Comment])) but I don't understand why?  The week column should never have a blank in the field as it is populated from the start of a project to the thend of the project.  it is the comment field that will have blanks in the column and I need to always extract the latest comment; which is always the last non-blank in that row as determined by max week date