How get the last value on a given date

[Anonymous]

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 worked:
Remainder:=
var a = CALCULATE(LASTNONBLANK('Table1'[RemDoc], 1),
FILTER(ALL('Date'),'Date'[DateKey] <= MAX('Table1'[DateKey])))
var b = IF((a<=0),0)
return a
******

Remainder:=
var suma = CALCULATE (SUM('Table1'[RemDoc]),
FILTER (ALL('Date'),'Date'[DateKey] <= MAX('Table1'[DateKey])))
var rem = IF((suma<0),0,suma)
return rem

******

Остаток:=
SUMX (VALUES ('Table1'[Partner]),
VAR LastBalanceDate = CALCULATE ( MAX ( Table1'[DateKey] ) )
RETURN
CALCULATE (
SUM ('Table1'[RemDoc]),
'Date'[DateKey] >= LastBalanceDate))
****
How to achieve the desired result?
Thanks for your helps.

[V-pazhen-msft]

@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.

[Anonymous]

@V-pazhen-msft 

can't calculate the lastdate()

[V-pazhen-msft]

@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]

@V-pazhen-msft  can you help me?

[Anonymous]

@V-pazhen-msft 

Yes, error. Did as in your exemple.

[lbendlin]

remember you need to control the filter context for Calculate(), otherwise it will only calculate it for the "current row"

[Anonymous]

@lbendlin can you show an example?

[lbendlin]

Don't use functions inside CALCULATE() filters. They get impacted by the context transition. Define your filters as variables before using them in CALCULATE().

[Anonymous]

@lbendlin how to do it? Define filters as variable

[lbendlin]

Like you do it in your last example.

[Anonymous]

@lbendlin  
So:
VAR LastBalanceDate = CALCULATE(MAX( 'Table1'[DateKey]))
RETURN
CALCULATE(
LASTNONBLANK('Table1[RemDoc],SUM('Table1'[RemDoc])),
'Date'[DateKey] <= LastBalanceDate)

Or so:
LASTNONBLANK(VALUES ('Table1'[RemDoc]),
VAR LastBalanceDate = CALCULATE(MAX( 'Table1'[DateKey]))
RETURN
CALCULATE(
SUM ('Table1'[RemDoc]),
'Date'[DateKey] <= LastBalanceDate))

both options don't work