Forum Discussion
How get the last value on a given date
Hi all. I have table: that false. Would like to see the remainder from 12885,82625 as of 04.12.2019 More samples as I want to see: I try next queries, but nothing correct work...
Anonymous
What you have tried is running total, to return latest date value, try create this measure using lastdate():
Measure = CALCULATE(SUM('Table1'[RemDoc]),LASTDATE('Table1'[Date]))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Anonymous
can't calculate the lastdate()
Anonymous
What do you mean you can't? Is there any error message?
You use calcuate() to call out the [Remdoc] column value, and filter to the lastdate of the given date.
Paul
Anonymous
Yes, error. Did as in your exemple.
Anonymous can you help me?