Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, here's my problem. I have three tables:
Table 1 is a table of events, with the following columns: Event ID, Date, Time, Truck Number, Zone, etc
Table 2 and 3 have the following columns: ID, Truck Number, Date, Time, Cost, etc
I want to create two calculated columns in table 1, called "Cost of Manteinance" and "Cost of Fuel".
The cost of manteinance of one event is the cost of the closest manteinance of the corresponding truck number (done before the event) divided by the number of events of the corresponding truck that are between said mantainance and the following corresponding mantainance. Tha same should be done for "Cost of Fuel".
I other words, I want to prorate the cost of every manteinance work (and fuel load) between the corresponding events of every truck. In the end the sum of the costs of every event should be equal to the sum of the costs of tables 2 and 3.
How can this be done?
I'm not so sure if this is the correct approach to prorating costs. If you have any better ideas please let me know!
Hi @ivan_xd
Please share some data and the output expected. You can put it in OneDrive and provide the link.
Cheers
CheenuSing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |