I have a table where I get the status of the employee's tasks day by day.
As in the below image, I get the values(Confidential, so just entered dummy data).
Then I unpivoted the dates column and made a copy of that and split with space so that I can get the date value.
Here I would like to show the last 3 commented values in a table visualization for each task.
Like as in the above image, if the 5/31/2017 value is not available, then it should get the values of 5/29/2017 plan, 5/29/2017 actual, 5/30/2017 plan values i.e nothing but the last 3 non-blank values.
Any suggestions, please.