Forum Discussion

pbiuser1122's avatar
pbiuser1122
Frequent Visitor
2 years ago

How to ignore first value shown in line graph when using a moving range measure

Hi, I've encountered an issue when populating a line graph with a moving range calculation.    The screenshot below shows the graphs that I have. - The first graph simply shows mean values over ti...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

pls 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

 

pbiuser1122's avatar
pbiuser1122
Frequent Visitor
2 years ago

I created an example file but do not see an option to attach a pbix file.

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    upload to onedrive or another

  • pbiuser1122's avatar
    pbiuser1122
    Frequent Visitor
    2 years ago

    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