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.
i have posted this question twice before but the provided answer did not solve the case.
im trying to find the previous day closing price for stocks so that i can calulate day on day change. the problem is stock market is not open everyday and in the days when the market is closed previous day price will be blank.
im using the following measure but it's not returning the intended output when i present it in card visual or in scroller custom visual
as in the image, the measure works in table visual format but doesnt give last date nonblank value in the card visual.
the expected output in the card visual should be 142.16 instead of 131062.04
appreciate the support as this is an urgent matter.
Solved! Go to Solution.
@lawada4 Try:
DOD Change Measure =
VAR __Date = MAX('Table'[Date])
VAR __Price = MAX('Table'[last closing price])
VAR __PrevDate = MAXX(FILTER(ALL('Table'), [Date] < __Date && [last closing price] <> BLANK(),[Date])
VAR __PrevPrice = MAXX(FILTER(ALL('Table'), [Date] = __PrevDate), [last closing price])
VAR __Result = DIVIDE( ( __Price - __PrevPrice ), __Price, 0 )
RETURN
__Result
Hi @lawada4
Can you provide your sample to us so that we can deal with your question better ?
Best Regards,
Community Support Team _ Ailsa Tao
@lawada4 Try:
DOD Change Measure =
VAR __Date = MAX('Table'[Date])
VAR __Price = MAX('Table'[last closing price])
VAR __PrevDate = MAXX(FILTER(ALL('Table'), [Date] < __Date && [last closing price] <> BLANK(),[Date])
VAR __PrevPrice = MAXX(FILTER(ALL('Table'), [Date] = __PrevDate), [last closing price])
VAR __Result = DIVIDE( ( __Price - __PrevPrice ), __Price, 0 )
RETURN
__Result
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |