Forum Discussion

giovissimo's avatar
giovissimo
Helper I
5 years ago

Problem Calculating the Kilometers driven

Hello, first of all, sorry if my problem has been solved already; I found a similar question, but not exactly the same. My table contains the following fields: Date (which is not relevant), Driver,...
Need Help
giovissimo's avatar
giovissimo
Helper I
5 years ago

Thanks for replying in the first place.

Unfortunately, the error message is the same as the one prieviously mentioned (i.e., that the row context EARLIER refers to actually doesn't exist).

 

Translated, it says that EARLIER refers to a row context which doesn't exist

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

Hi , giovissimo ,

 

so you have to add index column, steps as follows:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • giovissimo's avatar
    giovissimo
    Helper I
    5 years ago

    Thank you, nonetheless apparently I have a different menu, and when I try to add a new column, I don't get to specifiy the type of data, since as I click on to the "Tipo di Dati" menu on the left, the column disappears.

    My version is the 2.92.1067.0 64-bit (April 2021). 

     

  • giovissimo's avatar
    giovissimo
    Helper I
    5 years ago

    I've bypassed the problem by importing the table in Access, inserting the Index (counter) column and then exporting it again in Excel, from where I imported it in PowerBI 🙂

    Nonetheless, the error message remains 😞