PowerBI: Last 3 Non Blank Values from column

Question

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

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

Then I did 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 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.

Mohan V

Have you checked [`TOPN`](https://msdn.microsoft.com/en-us/library/gg492198.aspx) dax function? — user5226582, May 31 '17 at 06:45
@user5226582 Not actually. I am just new to power bi and the dax. Can you give a hint please. — Bunny, May 31 '17 at 06:47
Thanks for the hint @user5226582. It worked. I did it by mentioning Top 3 in visual level filters — Bunny, May 31 '17 at 07:29

score 2 · Accepted Answer · answered May 31 '17 at 07:35

2

I think i got the solution. I did mentioned in Top N filtering of visual level filter of fields.

And it worked for me.

Thanks for the hint @user5226582

answered May 31 '17 at 07:35

Bunny

409
3
21

looks great! Make sure to mark this as the answer :) – Carl Walsh Jun 02 '17 at 20:41

PowerBI: Last 3 Non Blank Values from column

1 Answers1