negro57New Member9 years agoSolvedWeekly 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 ...Show MoreVvelarde to negro579 years ago negro57 create a calculated colum: KRecorridosP = CALCULATE ( SUM ( Table1[Kilometros] ), FILTER ( ALLEXCEPT ( Table1,Table1[Dominio] ), Table1[Fecha] = EARLIER ( Table1[Fecha] ) - 7 ) )
Vvelarde to negro579 years ago negro57 create a calculated colum: KRecorridosP = CALCULATE ( SUM ( Table1[Kilometros] ), FILTER ( ALLEXCEPT ( Table1,Table1[Dominio] ), Table1[Fecha] = EARLIER ( Table1[Fecha] ) - 7 ) )
Vvelarde to negro579 years ago negro57 create a calculated colum: KRecorridosP = CALCULATE ( SUM ( Table1[Kilometros] ), FILTER ( ALLEXCEPT ( Table1,Table1[Dominio] ), Table1[Fecha] = EARLIER ( Table1[Fecha] ) - 7 ) )
negro57New Member9 years agoI need in each row to calculate the number of km made by the vehicle from the previous load
negro57New Member to negro579 years ago I do not understand why it does not complete the data in the column (column)
Related contentWeekly AverageDistance (in kilometers) between adressesShow Number of Kilometers travelledWeekly visualizationEmail a weekly Excel report
