Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
PD_ASC
New Member

fuel consumption measurement

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

1 ACCEPTED SOLUTION
v-xuding-msft
Community Support
Community Support

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!

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xuding-msft
Community Support
Community Support

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!

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jimmy801
Community Champion
Community Champion

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors