Forum Discussion

negro57's avatar
negro57
New Member
9 years ago
Solved

Weekly kilometers

I have a table where I register the kilometers that have the vehicles, I want to know the kilometers that traveled, subtracting the settlers the previous week and the settled ones this week. What ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

     

    negro57

     

    create a calculated colum:

     

    KRecorridosP =
CALCULATE (
    SUM ( Table1[Kilometros] ),
    FILTER ( ALLEXCEPT ( Table1,Table1[Dominio] ), Table1[Fecha] = EARLIER ( Table1[Fecha] ) - 7 )
)

     

     

     

negro57's avatar
negro57
New Member
9 years ago

 

 

  • negro57's avatar
    negro57
    New Member
    9 years ago

    I need in each row to calculate the number of km made by the vehicle from the previous load

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

       

      negro57

       

      create a calculated colum:

       

      KRecorridosP =
CALCULATE (
    SUM ( Table1[Kilometros] ),
    FILTER ( ALLEXCEPT ( Table1,Table1[Dominio] ), Table1[Fecha] = EARLIER ( Table1[Fecha] ) - 7 )
)

       

       

       

      • negro57's avatar
        negro57
        New Member
        9 years ago

        So now I only have to subtract kilometers and this column excellent thousand thanks

    • negro57's avatar
      negro57
      New Member
      9 years ago

       

      I do not understand why it does not complete the data in the column (column)