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
oitp's avatar
oitp
Helper I
6 years ago

Thanks az38, but this will get me a blank result. I do not get any errors but the measure is empty. Can it be something wrong with the format of the Counter column?

az38's avatar
az38
Community Champion
6 years ago

oitp 

maybe you've got the other fields?

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

  • oitp's avatar
    oitp
    Helper I
    6 years ago

    I have updated the measure to match my fields and tables. I think there is something wrong with my tables and relationships. The table I have explained is actually a table based on relationships. I have to look into that I believe 🙂

    • 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? 🙂