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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • giovissimo's avatar
    giovissimo
    Helper I
    5 years ago

    Thank you, only I don't have any index column in my table: is it absolutely necessary to add it ?

    Is it linked to any existing column ?

     

    Giovanni

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      You are welcome.  The Index column was created in the Query Editor.  See the steps in the Query Editor. 

      • giovissimo's avatar
        giovissimo
        Helper I
        5 years ago

        Thank you again for devoting your time to the solution of my problem.

        I've just taken a look at all the steps in the query editor, but unfortunately I can't understand the meaning of that Index column (it's obviously my fault). As far as I can see, it's not linked to the driver, neither to the car.

        Isn't it possible to solve the problem without resorting to that Index column ? Just asking.

         

        Giovanni