Calculate Standard Deviation basin on rolling average

[Sandhya877]

Hi Everyone, 

Need some dax expertise. 

I have a table with columns Date, Product Cost, Sales Cost.

created a measure Rolling average = 12 months rolling average on Sales cost

created Value3 measure = Product cost/sales cost

I need to create a measure to calculate Standard Deviation only for the years 2019 and 2020

when i do this the values for 2018 are begin filetered out and i am getting high values.

How can i calucalte a measure with out being filtered out ?

Below is the sample data in excel

[lbendlin]

Please read about the window functions in DAX.  You will need to define what "12 months rolling average" means relative to the current filter context.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...