Forum Discussion
Find current value based on date from data
Hi guys anyone help me with this one - im wanting to for any given date, pull the value against the ID 14/06/2021 UK-Education-Schools 5 24/06/2021 UK-Education-Schools 3 24/0...
Hi Parry 2K
thank you for the link, I will do my best to present the questions more approperately in future.
in excell i used the formula =VLOOKUP(CONCAT($I1,MAXIFS($B:$B,$A:$A,$I1)),$C:$D,2,FALSE)
but i dont know how that translates to PBI
| A | B | C | D | E | F | G | H | I | |
| 1 | A | 01/06/2021 | 1 | A | 100 | ||||
| 2 | A | 02/06/2021 | 5 | B | 33 | ||||
| 3 | A | 03/06/2021 | 3 | C | 8 | ||||
| 4 | A | 04/06/2021 | 4 | new table | |||||
| 5 | A | 05/06/2021 | 5 | ||||||
| 6 | A | 05/06/2021 | 5 | ||||||
| 7 | A | 07/06/2021 | 7 | ||||||
| 8 | B | 01/06/2021 | 4 | ||||||
| 9 | B | 02/06/2021 | 2 | ||||||
| 10 | C | 03/06/2021 | 1 | ||||||
| 11 | C | 04/06/2021 | 4 | ||||||
| 12 | C | 05/06/2021 | 5 | ||||||
| 13 | A | 19/12/2021 | 15 | ||||||
| 14 | A | 25/12/2021 | 20 | ||||||
| 15 | B | 15/07/2021 | 6 | ||||||
| 16 | C | 02/01/2021 | 17 | ||||||
| 17 | C | 09/09/2021 | 8 | ||||||
| 18 | A | 31/12/2021 | 100 | ||||||
| 19 | B | 31/12/2022 | 33 | ||||||
| 20 | B | 01/01/1990 | 5 | ||||||
| data set |