Forum Discussion

oitp's avatar
oitp
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity 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

oitp's avatar
oitp
Icon for Helper I rankHelper I
6 years ago

Hi, I am not sure about what you mean with this stage? Should I create a new measure for this and then just show it through a table or so?

 

2. create and show result calculation a measure 

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