cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gareth_Hunt
Helper II
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 

Gareth_Hunt_0-1624632691778.png

 

14/06/2021UK-Education-Schools5
24/06/2021UK-Education-Schools3
24/06/2021UK-Education-Universities5
24/06/2021UK-Healthcare-Care Homes1

 

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
Gareth_Hunt
Helper II
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 

 

 

 ABCDEFGHI
1A01/06/20211    A100
2A02/06/20215    B33
3A03/06/20213    C8
4A04/06/20214    new table 
5A05/06/20215      
6A05/06/20215      
7A07/06/20217      
8B01/06/20214      
9B02/06/20212      
10C03/06/20211      
11C04/06/20214      
12C05/06/20215      
13A19/12/202115      
14A25/12/202120      
15B15/07/20216      
16C02/01/202117      
17C09/09/20218      
18A31/12/2021100      
19B31/12/202233      
20B01/01/19905      
 data set        

 

 

 

parry2k
Super User
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.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490






Did I answer your question? Mark my post as a solution.

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





Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.