how to create a measure to return value for previous nonblank date

[lawada4]

im trying to create a measure that returns the closing price for the previous day for a stock. however in some days the stock market is closed so the previous date in this case will be blank. 

i used the following measure to get the value for last non blank date but its only working in table visual when the date field is added

previous day price1 = CALCULATE(SUM('stocks data'[Close]), OFFSET(-1,ALLSELECTED('stocks data'[Date]),ORDERBY('stocks data'[Date],ASC)))

when i added the measure to card visual it's returing the sum value of the previous closing price instead of the previous day.

in the selected date period , the previous nonblank date is 12-9-2022 and the measure should return142.16 and the day on day change value should be 1.61%

any idea on how to fix the measure?

[Mahesh0016]

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[lawada4]

im looking to have the output in a card visual not in a table format per row.  the result should be 142.16 instead of the sum of all values which is 131062.04

[Mahesh0016]

previous day price1 = CALCULATE(

SELECTEDVALUE('stocks data'[Close])

, OFFSET(-1,ALLSELECTED('stocks data'[Date]),ORDERBY('stocks data'[Date],ASC)))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[lawada4]

i have used same measure as i mentioned up but it's not returning correct value in card visual so still didnt solve my problem. any idea on how to modify the measure to get the intended output?