Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mhsk
Helper II
Helper II

reference next row from measure

Hi!

i'm trying to get a next row of an already calculated measure, i tried multiple scenarios and approaches but would need your help.

 

So my goal is to show calculated measure Order_LOT_sum value in previus row, so value from November in October, value from December in November etc, so move it -1 row.

I can not use calculated column, just a measure. This measure Order_LOT_sum is calculated upon other measures, general goal is to calculated projected quantity. Calculations are as in file, so QOH - Requirement + Delivery and once this calculation goes below 0 then add in previous month an Order (OrderQty_parameter) (that is calculation based on parameter). So i need to catch not the moment with Balance <0 not the previous month to that moment but 2 month prior i will have Balance<0.

 

mhsk_0-1634641556602.png

 

 

.pbix file for download: https://easyupload.io/my3ktm

2 REPLIES 2
mhsk
Helper II
Helper II

no, unfortunately this did not worked, maybe any concept with earlier? i tried referencing index and for manual index=1-1 index = 2-1 works but thats a slow and dirty option

lbendlin
Super User
Super User

Try out the Running Total Quick Measure

 

lbendlin_0-1634678190496.png

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.