Forum Discussion
How to ignore first value shown in line graph when using a moving range measure
When I try your measure as a separate measure, it does not give the desired output:
The Moving Range line is what my desired output is but with the first value being ignored.
Your suggested Measure is returning the Sum of Mean Value that the Moving Range Measure is built off of.
Super Userpls try this
if this doesn't help then share the file
Moving Range =
VAR _MinDate =
MINX ( ALLSELECTED ( 'Data' ), 'Data'[Created On] )
VAR EarlierTime =
CALCULATE (
MAX ( 'Data'[Created On] ),
FILTER (
ALLSELECTED ( 'Data'[Created On] ),
'Data'[Created On] < SELECTEDVALUE ( 'Data'[Created On] )
&& 'Data'[Created On] > _MinDate
)
)
VAR EarlierMeasureValue =
CALCULATE ( [Sum of Mean Value], 'Data'[Created On] = EarlierTime )
VAR Moving_Range =
ABS ( EarlierMeasureValue - [Sum of Mean Value] )
RETURN
Moving_Range
I created an example file but do not see an option to attach a pbix file.
- Ahmedx
upload to onedrive or another
Ahmedx Sorry for delayed response, I had to check my companies policies. Unfortunately I cannot share the exact file due to confidentality. However, I created an example file where I pulled a snippet of data from the original file and recreated the issue I am running into. The original file has far more data.
Here is the a link to download the example file: Example File