Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts
How could you calculate the STDEV,S for the last 90 days as a calculated column in power bi
Excel formula - =STDEV.S(AW4:AW93)*SQRT(252)
Solved! Go to Solution.
FAME0 90-Day Volatility 2 =
var current_day = BioDiesels[Date]
return
STDEVX.S(
FILTER(
ALL(BioDiesels),
BioDiesels[Date] in DATESINPERIOD(DimDate[Date], current_day, -90, DAY)
),
BioDiesels[FAME0 Price Interday]
)
Proud to be a Super User!
https://dash-intel.com/powerbi/statistical_functions_stdev.php
Proud to be a Super User!
Hi bolfri. That does not work I tried it. Unless you can roof me wrong?
Boyfriend? 😂
Can you share sample data or something? Nameing of your calendar table? Then I can help with DAX. It's all about running -90 days on calendar to the current date on your table.
Proud to be a Super User!
Boyfriend? - Auto correct. LOL
1. i satrted the calculation (calculated column measure)
FAME0 90-Day Volatility 2 =
var current_day = BioDiesels[Date]
return
STDEVX.S(
FILTER(
ALL(BioDiesels),
BioDiesels[Date] in DATESINPERIOD(DimDate[Date], current_day, -90, DAY)
),
BioDiesels[FAME0 Price Interday]
)
Proud to be a Super User!
Hi thanks for the feedback butthe expexted end result did not agree with excel
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |