Forum Discussion

oitp's avatar
oitp
Helper I
6 years ago

Sum latest values based on date (duplicate dates)

Hi, I have a table as the table describes. I want to sum the values that has the latest UpdatedDate. So if we keep the table as an example I want to sum the three rows with the UpdatedDate 2019-12-15...
Need Help
az38's avatar
az38
Community Champion
6 years ago

oitp you can show us data example and data model then we'll try to fix it together

do not hesitate to give a kudo to useful posts and mark solutions as solution

oitp's avatar
oitp
Helper I
6 years ago

How do I do that? Can I share something for you or do you want some print screens? 🙂

  • az38's avatar
    az38
    Community Champion
    6 years ago

    oitp 

    yes, screenshots. ot ypu could upload ypur pbix-file to the cloud like https://uploadfiles.io/

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    • oitp's avatar
      oitp
      Helper I
      6 years ago

      Thanks az38 ! I sent you the pbix-file through PM now 🙂

      • az38's avatar
        az38
        Community Champion
        6 years ago

        Hi oitp 

        ive reached the limit for number of private messages 🙂

        try:

        1. add measure to the left table visual

        2. create and show result calculation a measure 

        calculate(max(Table1[Updated Date]);all(Table1))

         do not hesitate to give a kudo to useful posts and mark solutions as solution