Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

lbendlin how to do it? Define filters as variable

lbendlin's avatar
lbendlin
Super User
5 years ago

Like you do it in your last example.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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