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.
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
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |