topic Re: Extract value last date in DAX Commands and Tips

Extract value last date

dofrancis3 — Mon, 18 Mar 2024 16:48:48 GMT

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:

Re: Extract value last date

Greg_Deckler — Mon, 18 Mar 2024 16:53:23 GMT

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

Re: Extract value last date

Anonymous — Wed, 27 Mar 2024 08:03:22 GMT

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.