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
We would like your help, in order to have some ideas on this. We need to calculate the average fuel consumption, unfortunately we only have the total fuel consumed since the machine started, and every day we have a change. we could take one value from the other, but the thing is that for example at weekends or when the machine is not working, this doesn´t work. we need to find rule in order to overtake this
Can you help us
Thanks in advance
BR
PD
Solved! Go to Solution.
Hi @PD_ASC ,
Is there any date records? like the first day that it starts working and its broken day. If you just have a total fuel consumed value, unfortunately, I don't think we can calculate the average values correctly.
If you have resolved this issue, welcome to share your solution. More people will benefit from this thread. If you still need help, please share more details with us. Thanks!
Hi @PD_ASC ,
Is there any date records? like the first day that it starts working and its broken day. If you just have a total fuel consumed value, unfortunately, I don't think we can calculate the average values correctly.
If you have resolved this issue, welcome to share your solution. More people will benefit from this thread. If you still need help, please share more details with us. Thanks!
Hello @PD_ASC
the machine is not working only the weekends?
If so, take the total amount of fuel and divide it of working days from today - first day of operating of the machine.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
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.