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

hi oitp 

try a measure

Measure = calculate(Sum(Table1[Counter]);filter(all(Table1);Table1[Updated Date]=calculate(max(Table1[Updated Date]);all(Table1))))

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, 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