Get the value for the previous non blank date

Hi everybody,

I'm trying to calculate a Day On Day Change for a set of stocks. The thing is, when it comes to getting the previous day value, there are sometimes where Dax returns me a blank value since there's a weekend in between. 

I guess this is because my formula has flaws... I'd like just to have the previous day value as it happens when it's labour day. 

Formula and tables are:

Latest ULSD 10ppm MED (€/l) = CALCULATE (

     AVERAGE('ULSD 10ppm CIF MED'[Litres EUR Prevat]),

     FILTER ('ULSD 10ppm CIF MED',

         'ULSD 10ppm CIF MED'[Date]

             = CALCULATE (

                 LASTNONBLANK ( 'ULSD 10ppm CIF MED'[Date], 1 ),

                 FILTER (

                     'ULSD 10ppm CIF MED',

                      'ULSD 10ppm CIF MED'[Date] <= LASTDATE( 'ULSD 10ppm CIF MED'[Date])))))

PR ULSD 10ppm MED CIF Cargoes (€/l) = 
IF(ISBLANK([Latest ULSD 10ppm MED (€/l)]),
 [Latest ULSD 10ppm MED (€/l)],
    CALCULATE (
     AVERAGE('ULSD 10ppm CIF MED'[Litres EUR Prevat]),
        PREVIOUSDAY('CALENDAR'[Date])))

DoD Change ULSD 10ppm MED CIF Cargoes (€/l) = 
Var Division = DIVIDE([Latest ULSD 10ppm MED (€/l)] - [PR ULSD 10ppm MED CIF Cargoes (€/l)], [PR ULSD 10ppm MED CIF Cargoes (€/l)])
Return
Division 

Expected Results are: 

Appreciate any help.