Forum Discussion

ddurosier's avatar
ddurosier
Frequent Visitor
6 years ago
Solved

Working with Filters and Lastnonblank

Hi all, was hoping someone can quickly help because I've been trying to figure this out yesterday. I have some extra filters I want to add but just want a head start on how to get that going. Basical...
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    maybe

     

    VAR __last = MAXX(FILTER('Table',NOT(ISBLANK('Table'[comment])),[date])

    RETURN

    MAXX(FILTER('Table',[date]=__last),[comment])

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ddurosier ,

 

Please check the formula below.

Measure = 
var maxdate = CALCULATE(MAX('Table'[date]),FILTER(ALL('Table'),'Table'[comment]<>BLANK()))
return
IF(SELECTEDVALUE('Table'[date])=maxdate,1,0)

Add this formula to visual filter and the result will be shown as below.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ddurosier's avatar
    ddurosier
    Frequent Visitor
    6 years ago

    For some reason this one I couldn't get it working.