Forum Discussion

dofrancis3's avatar
dofrancis3
Icon for Resolver I rankResolver 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.

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.