Forum Discussion
Calculate Standard Deviation basin on rolling average
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
1 Reply
- lbendlin
Super User
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-Forum/ba-p/963216
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/1447523
