Find current value based on date from data

[Gareth_Hunt]

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

[Gareth_Hunt]

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

[parry2k]

@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/38490