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/06/2021 | UK-Education-Universities | 5 |
| 24/06/2021 | UK-Healthcare-Care Homes | 1 |
so fr example if date slider was set to 15/06/2021 then for "UK-education-schools" i want to see the value "5", but if the date selection was 25/06/2021 then return the value "3" using a new table
2 Replies
Gareth_Hunt what is the logic to calculate the value? How you are getting those numbers? Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Hi 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
