Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
57 | |
21 | |
19 | |
16 | |
16 |
User | Count |
---|---|
86 | |
77 | |
52 | |
37 | |
22 |