Repeat last value

Hello igorabdo

I have normalized come columns and created the above model:

Then I have used the below measure to calculate the figures:

Avg Cost Last Non Blank =
SUMX (
    Periods,
    VAR curPer = Periods[DATA_INICIO]
    RETURN
        IF (
            ISEMPTY ( RELATEDTABLE ( data ) ),
            CALCULATE (
                SUM ( data[CUSTO_MEDIO] ),
                LASTNONBLANK (
                    CALCULATETABLE ( Periods, Periods[DATA_INICIO] <= curPer ),
                    COUNTROWS ( RELATEDTABLE ( data ) )
                )
            ),
            CALCULATE ( SUM ( data[CUSTO_MEDIO] ) )
        )
)

Which is yielding the below results  ( I have conditionally formatted in red the figures that are calculated using the LASTNONBLANK part )

I am not able to upload the file at the moment but if you still have doubts I will be able to upload it later in the day. 

igorabdo

You can download it here: https://1drv.ms/u/s!AiiWkkwHZChHjxV0PpsCKUIBzJVu