Forum Discussion
Resolver IPourcentage and latest date
Hello Guys!
Please i need your help
I would like to calculate and display the vaccination percentage for only the latest date for each count
Below exemple of my data
Hi dofrancis3 ,
Thanks for the new data, here are my changes to the second MEASURE:Percentage = CALCULATE( MAX('Table'[Number of vaccinated]), FILTER( 'Table', SELECTEDVALUE('Table'[Date of vaccination]) = [LastDate] ) )Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
5 Replies
- lbendlin
Super User
Do you want to do that in DAX or in Power Query?
dofrancis3Hi Guys!
I would like to extract (display) the percentage of vaccination for the latest date for each country.
Please the screen below:
- lbendlin
You can do that with grouping in Power Query
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi dofrancis3 ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:Create two dax
LastDate = CALCULATE( MAX('Table'[Date of vaccination]), ALLEXCEPT( 'Table', 'Table'[Country] ) )Percentage = VAR _number = CALCULATE( MAX('Table'[Number of vaccinated]), FILTER( 'Table', SELECTEDVALUE('Table'[Date of vaccination]) = [LastDate] ) ) VAR SumByCountry = CALCULATE( SUM('Table'[Number of vaccinated]), ALLEXCEPT( 'Table', 'Table'[Country] ) ) RETURN _number / SumByCountryFinal output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi dofrancis3 ,
Thanks for the new data, here are my changes to the second MEASURE:Percentage = CALCULATE( MAX('Table'[Number of vaccinated]), FILTER( 'Table', SELECTEDVALUE('Table'[Date of vaccination]) = [LastDate] ) )Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
