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.