Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |