Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |