Forum Discussion
Helper IVMoving Range DAX (subtract previous row values from earlier DateTime)
Helper IVThanks. This is really awesome. A DAX dummy can only achieve so much because of great folks like you!
rgds,
Vincent
Hi
This topic is really usefull and solution works very well
I try to adapt the code to add a process filter because we have many different measure on a machine and my goal is to filter the process that I want.
My data:
On measurement "Ealier" and "MovingRange" I have replaced [TimeSpc] by [Index], the MovingRange graph works correctly but I have trouble with the measurement of "MRBar" where the result is empty (probably due to blank value).
How can I have a mean measurement of the moving range with the same value that I have on the graph with the mean?
Any help will be really appriciated :-)
- vincentakatoh
The line chart visual provides an option to add a average line automatically. Does that helps?
btw.. On a side note, on Upper and Lower Control Limit for Xbar Chart, i did not find a way to auto calculate both UCL and LCL, then it came to my mind it is not requried. Reason being, from a statisic perspective, the UCL and LCL should be locked once process is stable. UCL and LCL should not change with new data.
vincentakatoh Yes for the mean MRBar average line automatically this is what I've done on my MR chart and it works well. My issue is that I need to have this value on a measurement to calculate after the Cpk.
If I used this calculation:
MRBar = AverageX(ALLSELECTED(List1[Value]); [MovingRange]) --> result is Empty
Seems that the mean function on the graph is different than this calculation.
Is it possible to catch the mean value from the graph directly?
Agree for UCL and LCL
ERIC_AHelper II
Hi
I am also adapting this to use the index instead of date because in my case, the date is repeated. The formula seems to do the calculation for the whole database but I want to limit this calculation to my slicer selection (month) How can I do this?