how to create a measure to return value for previous nonblank date
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?
