Return value from previous row

Question

I know that has been addressed a number of times in here.. but I just can't seem to make those examples work.&nbsp; Need to simply return the value from previous row.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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] )
        )
    )
)&nbsp;&nbsp;&nbsp;Somethings wrong with my Filter in the Calculate, but I can't work it out.&nbsp; Any help is appreciated.&nbsp;

amitchandak · Accepted Answer

Try as a new columnPrevious Row =
	
        MAXX(FILTER (
            'Segment Data',
            'Segment Data'[Segment date] = EARLIER ( 'Segment Data'[Segment date] )
			'Segment Data'[Segment Start] &lt; 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] )&nbsp;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-trendPower-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-RangesConnect on Linkedin

Forum Discussion

Return value from previous row

2 Replies

Related content

Measure returning incorrect value

Return value of previous column

Date Different return wrong value

Previous month dax returning balnk

Getting value for previous year based on value name and year slicer