Forum Discussion
Return value from previous row
- 6 years ago
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
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
Worked perfectly. Understand where I was wrong now that I see it working! Thanks for the help!