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 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:
expected result:
any idea on how to fix the measure to calculate previous stock price based on the last non blank date
Please share exepacted result snap shot for understanding.
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
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 |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
57 | |
50 | |
44 | |
21 | |
19 |