Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 I need is to know the weekly kilometers traveled and to be able to compare with the routes in the previous weeks
Sorry for my english, I hope you understood me, thank you
Solved! Go to Solution.
create a calculated colum:
KRecorridosP = CALCULATE ( SUM ( Table1[Kilometros] ), FILTER ( ALLEXCEPT ( Table1,Table1[Dominio] ), Table1[Fecha] = EARLIER ( Table1[Fecha] ) - 7 ) )
I need in each row to calculate the number of km made by the vehicle from the previous load
I do not understand why it does not complete the data in the column (column)
create a calculated colum:
KRecorridosP = CALCULATE ( SUM ( Table1[Kilometros] ), FILTER ( ALLEXCEPT ( Table1,Table1[Dominio] ), Table1[Fecha] = EARLIER ( Table1[Fecha] ) - 7 ) )
So now I only have to subtract kilometers and this column excellent thousand thanks
Hi @negro57,
Could you please share your data sample or data structure and your expectation as picture? so I could quickly figure out and propose solution.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |