cancel
Showing results for
Did you mean:
Helper II

## 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 2
Helper II

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

Super User

@Gareth_Hunt what is the logic to calculate the value? How you are getting those numbers? Read this post to get your answer quickly.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Announcements

#### Launching new user group features

Learn how to create your own user groups today!