Forum Discussion

trixie_dreadful's avatar
trixie_dreadful
Microsoft Employee
6 years ago
Solved

Getting date for max value

Hello!   I'm looking at COVID daily data.    My main table looks like this: dateRep deaths countriesAndTerritories 3/1/2020 1 Australia 3/1/2020 35 China 3/...
Need Help
Tutorial Requests
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi trixie_dreadful ,

     

    We can create a calculate column in your calculate table.

     

    Create a new column named MaxDeathDate in DeathsbyCountry table.

     

    MaxDeathDate =
CALCULATE (
    MAX ( 'Table'[dateRep] ),
    FILTER (
        'Table',
        'Table'[countriesAndTerritories] = DeathsbyCountry[Table_countriesAndTerritories]
            && 'Table'[deaths] = DeathsbyCountry[Max Death]
    )
)

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

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