I want to retrieve previous row Net Price for same article code and compare it with present row netprice and store the prevnetprice and calculate the price change. need to store the price change and MRINDate (PODATE) of change

Power BI
2

I have solved this by creating IndexCol, but indexcol values are jumping after 14 ( to 30) and after 28-29 ( to 60), i checked the data, i didn’t find any discrepancy, enclosing the revised pbix
DNAcost22SeptCORRECTtPrevNetPriceDAX—workingonIndexColValues.pbix (212.5 KB)