Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
.pbix file for download: https://easyupload.io/my3ktm
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
Try out the Running Total Quick Measure
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |