Forum Discussion

dofrancis3's avatar
dofrancis3
Resolver I
2 years ago
Solved

Extract value last date

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's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.