Extract value last date

[dofrancis3]

Hi Guys!

I need your help!

would like to extract (display) the percentage of vaccination for the latest date for each country.

Please the screen below:

[Anonymous · Accepted solution]

Hi @dofrancis3 

Thank you for your prompt reply @Greg_Deckler.

Here I have another idea in mind, and I would like to share it for reference.

Hope the following dax will help you.

Measure = 
var latest_date = MAX('Table (2)'[Date of  vaccinated])
RETURN CALCULATE(SELECTEDVALUE('Table (2)'[Number of  vaccinated]),FILTER('Table (2)','Table (2)'[Date of  vaccinated]=latest_date))

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@dofrancis3 (1) Lookup Min/Max - Microsoft Fabric Community