Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Get Last 3 Non Blank values from a Column

Hello All, I have table as follows.   Here i need to get the values of 5/31/2017, 5/30/2017 and 5/29/2017 values from comments columns if my table contains comments column as   I.e ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    I think i got the solution.

    I did mentioned in Top N filtering of visual level filter of fields.

    enter image description here

    And it worked for me.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Will have to do some work on this, but how about something like this?

 

Last3Blanks = var LastBlank = CALCULATE(MAX('Calendar'[Date]),FILTER('Calendar','Calendar'[Comments]=""))
RETURN CONCATENATEX(CALCULATETABLE(VALUES('Calendar'[Date]),FILTER('Calendar','Calendar'[Date]<=LastBlank && 'Calendar'[Date] >= LastBlank-2)),'Calendar'[Date],",")
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks for the reply Greg_Deckler

    I did tried what you have suggested.

    i didnt get any errors but i didnt get any output also.

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Hmm, what data set are you using with that? Looks OK formula-wise. I did not try the use case where there are no blanks.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Greg_Deckler please have a look at the below reply.

        I have given info about the data that i am working.