Calculated indexcol,-Created using DAX Values are jumping

Power BI
1

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

1 day

I am trying to solve 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 (110.7 KB)

3

What is are you expecting the results to be? Provide a file with a solution that you are expecting would really the people in the forum to help you.

Please provide as much information as you so we aren’t spend our spare time going around in circles.

thanks
keith