Calculate Standard Deviation between dates

[cbruhn42]

I'm looking at standard deviation for fill volumes on multiple filling heads on the same machine.  I'm using a slicer to look at different date ranges currently, but what I'd like to do is calculate the fill volume standard deviation from the last time the valve was rebuilt or had maintenance done on it.  Any ideas?

My columns are:

Query1[Valve Number]

Query1[Fill Volume]

Query1[Last Rebuild Date]

Ideally I'd like to be able to look at a valve and see the std deviation prior to the maintenance using the slicer and then have another column showing the std deviation from samples taken after the last

[v-chuncz-msft]

@cbruhn42 

You may try STDEVX.S and TOPN to add a measure.

https://community.powerbi.com/t5/Desktop/Month-on-Month-YTD-Attrition-Percentage/m-p/526360#M246443