Missing dates in table, how to always show the latest known value?

[PaulusB]

I am building a dashboard to show a stock porfolio. In het stock rates table I do not have rates for every day. Whatever date you choose in the slicer, the stock rate should be the latest available one in the stock rate table. By example at 31-12-2020 you will get the latest rates of 04-02-2020.

How do I get this measure or table?

ISIN-code	Stock Name	Stock rate	Date
US5949181045	Microsoft	102,80	08-01-2019
US0846707026	Berkshire Hathaway	196,31	08-01-2019
US5949181045	Microsoft	180,12	04-02-2020
US0846707026	Berkshire Hathaway	225,08	04-02-2020
US0846707026	Berkshire Hathaway	292,52	4-6-2021
US5949181045	Microsoft	216,51	13-11-2020

[MFelix · Accepted solution]

Hi @PaulusB ,

You need to make use of the LASTNONBLANK something similar to this:

Measure = LASTNONBLANK('Table'[Stock rate], MAX('Table'[Date]))

[PaulusB]

Thanks Miguel, you directed me to the wright way to solve this problem!