dax formula to complete table with lastnoblank value

[GiuseppeTE]

Hello,

this is my first time in the comunity and I am a new user of power bi.

The issue I would like to solve is the follow:

I have to table like below:

where the table 1 have a calculated column with the following formula: 

Output calculated = SUMX(

                                   RELATEDTABLE(Tabella2);

                                                 Tabella2[outputactual]

                                 )

now the issue is:

how I can fill the rest of blank value in the column calculated  with the last one value (15) ? 

below the related table2:

thanks in advance for every one would like help me.

Giuseppe

[Zubair_Muhammad]

@GiuseppeTE 

Try this column

=
VAR lastavailabledata =
    CALCULATE (
        MAX ( Tabella2[dataworked] ),
        FILTER ( ALL ( Tabella2 ), Tabella2[dataworked] <= Tabella1[data] )
    )
RETURN
    CALCULATE (
        SUM ( Tabella2[outputactual] ),
        FILTER ( ALL ( Tabella2 ), Tabella2[dataworked] = lastavailabledata )
    )

[GiuseppeTE · Accepted solution]

Hello Muhammad,

your formula work perfectly.

thanks a lot

Giuseppe

[Zubair_Muhammad]

HI @GiuseppeTE 

Thanks for the feedback

Please mark the correct answer as solution. I see that you marked your own reply as ANSWER.