cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
levialae
Frequent Visitor

Daily value from cumulative number

Hi

 

I am trying to calculate the daily consumption of energy. The number I have is a cumulative value, so I need to subtract the value at end of day with beginning of day. However, I am not sure how to do this - can you please help me with this.

levialae_0-1629295252162.png

 

1 ACCEPTED SOLUTION

@levialae 

I  used some of your data in the screenshot. pls see the attachment.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
ryan_mayu
Super User
Super User

@levialae 

pls check if the attachment helps.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi Ryan

 

I think it worked but only partly. I have attached a new screenshot - it seems it only works on the first row, and I am not sure why that is.

levialae_0-1629360498881.png

Do you know why that might be?

@levialae 

I  used some of your data in the screenshot. pls see the attachment.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

This worked, thank you very much Ryan!

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.