Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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
previous day price1 = CALCULATE(
, 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 !!
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?