The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I currently have the following measure to calculate 2 moving averages:
- one on all gains
- another on all losses.
The averages are moving over the last 14 periodes within a timeframe (timestamps are ranked per timeframe), and timeframes can be hours, days, ... yet always having a respective timeframe. The following measure works, but I believe given it's pretty static, it should be calculated in a column instead of measure. Is this possible?
RSI = VAR GainCalc = abs(CALCULATE ( AVERAGEx(AllCandleData, [Gain]), filter(ALLEXCEPT ( AllCandleData,AllCandleData[Symbol],AllCandleData[Exchange],AllCandleData[Interval] ), AllCandleData[Rank] > (MAX(AllCandleData[Rank]) - 14 ) && AllCandleData[Rank] <= MAX(AllCandleData[Rank]) ) ) ) VAR LossCalc = abs(CALCULATE ( AVERAGEx(AllCandleData,[Loss]), filter(ALLEXCEPT ( AllCandleData,AllCandleData[Symbol],AllCandleData[Exchange],AllCandleData[Interval] ), AllCandleData[Rank] > (MAX(AllCandleData[Rank]) - 14 ) && AllCandleData[Rank] <= MAX(AllCandleData[Rank]) ) ) ) RETURN if(LossCalc=0 , 100 , 100-(100/(1+DIVIDE( GainCalc,LossCalc,BLANK()))))
Unfortunately, the result should be repeated on all timeframes. Similar to last non blank. Check below for screenshot. Can anyone help me out making this work on a measure, or convert this into a calculated column?
I don't mind making a measure or calculated column by timeframe ...
HI @wlknsn,
Can you please share some sample data for test?
Regards,
Xiaoxin Sheng
Of course, link to some sample data where the RSI is calculated using the measure mentionned above. Again, if we can have this is a calculated column, performance would probably seriously enhanced, but not a must.
Detail
Summary
Hi @wlknsn,
Due to policy I can't download sample file from shared link , can you please upload it to onedrive or google drive?
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |