PowerBI: last 3 non-empty values ​​from a column

Question

I have a table where I get the status of employees every day.

As in the following image, I get the values ​​(Confidential, so the dummy data just entered).

Then I turned off the date column and made a copy of this file and split it into a space to get the date value.

Here I would like to show the last 3 comments in the table visualization for each task.

As in the above image, if the value of 5/31/2017 is not available, then it should get the plan values ​​of 5/29/2017, the actual values ​​of 5/29/2017, 5/30/2017, i.e. nothing but the last 3 non-empty values.

Any suggestions please.

Mohan V

Answer 1

, . N .

.

@user5226582