how to get the value for the previous non blank date

[lawada4]

im trying to find previuos day price for stocks so that i can calculate Day on Day change. the problem is stock market is not open everyday and in this case some days will be blank when i calculate previous day price  . im using the following measure to get previous day stock price:

previous day price = CALCULATE(SUM('stocks data'[Close]), PREVIOUSDAY('stocks data'[Date]))

this is a screenshot of the measure results:

expected result:

any idea on how to fix the measure to calculate previous stock price based on the last non blank date 

[Mahesh0016]

Please share exepacted result snap shot for understanding.

[lawada4]

[Mahesh0016]

previous day price = CALCULATE(SUM('Stock'[Close Price]), OFFSET(-1,ALLSELECTED(Stock[Date]),ORDERBY(Stock[Date],ASC)))

@lawada4  Please try this.

If no work so can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data and OFFSET In -1 Or +1 set your conditions.

[lawada4]

the measure works only  in a table visual with the date field added in the table

however the measure is in card visual it doesnt give me value for the previous nonblank day but the sum of all values in the selected date period. 

previous day price measure should return 142.16 which is the closing price for the previous non blank date