Forum Discussion
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...
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
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))