Forum Discussion
DAX help
Hi, I am trying to calculate the below formula in Power BI as a calculated column: K = ( (C - L) / (H - L) ) * 100 Where: C = The current closing price (i.e the current row) L = Lowest cl...
Anonymous solution is attached, look at HLC and Calendar table, there are more tables in the file, just ignore those
Anonymous solution is attached, look at HLC and Calendar table, there are more tables in the file, just ignore those
parry2k Thanks for your response.
The L and H measures should cosider the previsous 14 days at every row level.
For example, for 12/10/2019 L and H values should take (12/10/2019 to 11/19/2019) date range into calculation.
Similarly, for 12/09/2019 row L and H values should take (12/09/2019 to 11/18/2019) date range.
Any thoughts on this?
Thanks