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 ) )
VvelardeCommunity Champion9 years ago negro57 create a calculated colum: KRecorridosP = CALCULATE ( SUM ( Table1[Kilometros] ), FILTER ( ALLEXCEPT ( Table1,Table1[Dominio] ), Table1[Fecha] = EARLIER ( Table1[Fecha] ) - 7 ) )
negro57New Member to Vvelarde9 years agoSo now I only have to subtract kilometers and this column excellent thousand thanks
Related contentWeekly AverageDistance (in kilometers) between adressesShow Number of Kilometers travelledWeekly visualizationEmail a weekly Excel report
