last non blank value on date without transaction

[RitaFFFF1233]

Hello,
There are two tables in my database: one with transaction date and transaction value, as shown in the table below.
Second, dates table.
For every day in the chosen period (by dates table), I need to show values. If there is no transaction on some day, I should show the last transaction with its value.
I tried using some variations of function LASTNONBLANK without success.
I would appreciate your assistance.
link to PBIX :
PBIX last no blank 

 

Date		sum
01/02/2023		3
02/02/2023		5
05/02/2023		6
06/02/2023		7
08/02/2023		8

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Lastnonblank value: = 
VAR _currentyear =
    MAX ( DateTable[Year] )
VAR _lastnonblankyear =
    CALCULATE (
        LASTNONBLANK ( DateTable[Year], [totalValue] ),
        FILTER ( ALL ( DateTable[Year] ), DateTable[Year] <= _currentyear )
    )
RETURN
    IF (
        HASONEVALUE ( Suppliers[SupplierName] ),
        CALCULATE ( [totalValue], DateTable[Year] = _lastnonblankyear )
    )

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Lastnonblank value: = 
VAR _currentyear =
    MAX ( DateTable[Year] )
VAR _lastnonblankyear =
    CALCULATE (
        LASTNONBLANK ( DateTable[Year], [totalValue] ),
        FILTER ( ALL ( DateTable[Year] ), DateTable[Year] <= _currentyear )
    )
RETURN
    IF (
        HASONEVALUE ( Suppliers[SupplierName] ),
        CALCULATE ( [totalValue], DateTable[Year] = _lastnonblankyear )
    )

[RitaFFFF1233 · Accepted solution]

 Thank you for your response.
I updated your code to 

Lastnonblank value: =

VAR _maxDate =

    MAX ( 'Table (2)'[Date] )

VAR _lastnonblankdate =

    CALCULATE (

        LASTNONBLANK ('Table (2)'[Date], [total sum]),

        FILTER ( ALL ('Table (2)'[Date]),'Table (2)'[Date] <= _maxDate )

    )

RETURN

         CALCULATE ( [total sum],'Table (2)'[Date] = _lastnonblankdate )

Worked perfectrly for me