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 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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