Return value from previous row

[nicholastrausch]

I know that has been addressed a number of times in here.. but I just can't seem to make those examples work.  Need to simply return the value from previous row.  

Previous Row =
IF (
    'Segment Data'[Segment ID] = 1,
    0,
    CALCULATE (
        MAX ( 'Segment Data'[Segment Total] ),
        FILTER (
            'Segment Data',
            'Segment Data'[Segment ID] = EARLIER ( 'Segment Data'[Segment ID] )
        )
    )
)

Somethings wrong with my Filter in the Calculate, but I can't work it out.  Any help is appreciated. 

[amitchandak · Accepted solution]

Try as a new column

Previous Row =
	
        MAXX(FILTER (
            'Segment Data',
            'Segment Data'[Segment date] = EARLIER ( 'Segment Data'[Segment date] )
			'Segment Data'[Segment Start] < EARLIER ( 'Segment Data'[Segment Start] )
        ) 'Segment Data'[Segment Total] )
  OR      
Previous Row =
	
        MAXX(FILTER (
            'Segment Data',
            'Segment Data'[Segment date] = EARLIER ( 'Segment Data'[Segment date] )
			'Segment Data'[Segment ID] = (EARLIER ( 'Segment Data'[Segment ID] ) -1)
        ) 'Segment Data'[Segment Total] )

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[nicholastrausch]

Worked perfectly.  Understand where I was wrong now that I see it working!  Thanks for the help!