STDEV.s for last 90 days - calculated column

[Anonymous]

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)

[bolfri]

https://dash-intel.com/powerbi/statistical_functions_stdev.php

[Anonymous]

Hi bolfri. That does not work I tried it. Unless you can roof me wrong?

[bolfri]

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.

[Anonymous]

Boyfriend? - Auto correct. LOL 

1. i satrted the calculation (calculated column measure) 

FAME0 90-Day Volatility = STDEV.S(BioDiesels[FAME0 Price Interday])*SQRT(252) - wrong

2. i need it for last 90 days based on column..FAME0 Price Interday

Sample Data

https://www.dropbox.com/s/2rmmueu8x4x9aug/sample_data.pbix?dl=0 

I found this on line - this might work but not sure on how to amend the DAX

Link: https://community.powerbi.com/t5/Desktop/STDEV-S-function-in-DAX-to-target-specific-cell-range/m-p/6...

thanks

Link: 

[bolfri · Accepted 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]
    )

[Anonymous]

Hi thanks for the feedback butthe expexted end result did not agree with excel

See excel 
https://www.dropbox.com/scl/fi/0jo9doga8xgdikvw46ajs/Excel-End-Result.xlsx?dl=0&rlkey=qnsm5luhd3juyu...