Difference from start of month to end of month in accumulative data

[Radan]

Hello,

Very inexperienced Power BI user here. I am working on automating out monthly production reporting and i need a way to calculate the difference in certain values, from the start of the month to the end of the month

My data is timestamped and historical production data is archived as an accumulative amount. How can i calculate the difference in a column from start of month to end of month, to see the actual production for that specific month?

Example of desired result: 

Start of january, column "00038" cell value = 60000

End of january, column "00038" cell value = 70000

Result of january = 70000-60000 = 10000 (<- I want to get to this value)

My data:

Regards, 

Rani

[Anonymous]

Hi, @Radan 

Based on the screenshot you gave, I cannot see the data for January, you can just post your data table (instead of the screenshot) to help me model your data faster.

Best Regards,
Yang
Community Support Team

[Radan]

Hello @Anonymous,

Thanks for reaching out.

Unfortunatly, I do not have specific data from january archived as seen above, due to having implemented a new data collection structure with our test plant. The data provided in the screenshot is pretty much all i have at the moment. 

I have copied my archived data below in a table:

00038

TimeStamp

6944740 6944740 6946140 6946140 6946140 6946140 6946140 6946140 6947530 6947530 6947530 6947530 6947530 6947530 6948920 6948920 6948920 6948920 6948920 6948920 6950310 6950310 6950310 6950310 6950310 6951700 6951700 6951700 6951700 6951700 6951700 6953090 6953090 6953090 6953090 6953090 6953090 6954490 6954490 6954490 6954490 6954490 6954490 6955890 0 6957290 6957290 6957290 6957290 6957290 6957290 6958690 6958690 6958690 6958690 6958690 6958690 6960090 6960090 6960090 6960090 6960090 6960090 6961490 6961490 6961490 6961490 6961490 6986640 6986640 6986640 6981080 6981080 6981080 6981080 6981080 6982340 6982470 6982470 6982470 6982470 6982470 6983620 6983860 6983860 6983860 6983860 6983860 6984870 6985250 6985250 6985250 6985250 6985250 6988030 6988030 6988030 6988030 6988030 6988030 6989450 6989450 6989450 6989450 6989450 6989450 6990850 6990860 6990860 6990860 6990860 6990860 6992260 6992270

2024-02-12 09:18:07.000 2024-02-12 09:28:07.000 2024-02-12 09:38:07.000 2024-02-12 09:48:07.000 2024-02-12 09:58:07.000 2024-02-12 10:08:07.000 2024-02-12 10:18:07.000 2024-02-12 10:28:07.000 2024-02-12 10:38:07.000 2024-02-12 10:48:07.000 2024-02-12 10:58:07.000 2024-02-12 11:08:07.000 2024-02-12 11:18:07.000 2024-02-12 11:28:07.000 2024-02-12 11:38:07.000 2024-02-12 11:48:07.000 2024-02-12 11:58:07.000 2024-02-12 12:08:07.000 2024-02-12 12:18:07.000 2024-02-12 12:28:07.000 2024-02-12 12:38:07.000 2024-02-12 12:51:04.000 2024-02-12 13:01:04.000 2024-02-12 13:11:04.000 2024-02-12 13:21:04.000 2024-02-12 13:31:04.000 2024-02-12 13:41:04.000 2024-02-12 13:51:04.000 2024-02-12 14:01:04.000 2024-02-12 14:11:04.000 2024-02-12 14:21:04.000 2024-02-12 14:31:04.000 2024-02-12 14:41:04.000 2024-02-12 14:51:04.000 2024-02-12 15:01:04.000 2024-02-12 15:11:04.000 2024-02-12 15:21:04.000 2024-02-12 15:31:04.000 2024-02-12 15:41:04.000 2024-02-12 15:51:04.000 2024-02-12 16:01:04.000 2024-02-12 16:11:04.000 2024-02-12 16:21:04.000 2024-02-12 16:31:04.000 2024-02-12 17:21:55.000 2024-02-12 17:32:58.000 2024-02-12 17:42:58.000 2024-02-12 17:52:58.000 2024-02-12 18:02:58.000 2024-02-12 18:12:58.000 2024-02-12 18:22:58.000 2024-02-12 18:32:58.000 2024-02-12 18:42:58.000 2024-02-12 18:52:58.000 2024-02-12 19:02:58.000 2024-02-12 19:12:58.000 2024-02-12 19:22:58.000 2024-02-12 19:32:58.000 2024-02-12 19:42:58.000 2024-02-12 19:52:58.000 2024-02-12 20:02:58.000 2024-02-12 20:12:58.000 2024-02-12 20:22:58.000 2024-02-12 20:32:58.000 2024-02-12 20:42:58.000 2024-02-12 20:52:58.000 2024-02-12 21:02:58.000 2024-02-12 21:12:58.000 2024-02-13 15:01:46.000 2024-02-13 15:11:46.000 2024-02-13 15:21:46.000 2024-02-13 10:41:05.000 2024-02-13 10:51:05.000 2024-02-13 11:01:05.000 2024-02-13 11:11:05.000 2024-02-13 11:21:05.000 2024-02-13 11:31:05.000 2024-02-13 11:41:05.000 2024-02-13 11:51:05.000 2024-02-13 12:01:05.000 2024-02-13 12:11:05.000 2024-02-13 12:21:05.000 2024-02-13 12:31:05.000 2024-02-13 12:41:05.000 2024-02-13 12:51:05.000 2024-02-13 13:01:05.000 2024-02-13 13:11:05.000 2024-02-13 13:21:05.000 2024-02-13 13:31:05.000 2024-02-13 13:41:05.000 2024-02-13 13:51:05.000 2024-02-13 14:01:05.000 2024-02-13 14:11:05.000 2024-02-13 14:21:05.000 2024-02-13 15:31:46.000 2024-02-13 15:41:46.000 2024-02-13 15:51:46.000 2024-02-13 16:01:46.000 2024-02-13 16:11:46.000 2024-02-13 16:21:46.000 2024-02-13 16:31:46.000 2024-02-13 16:41:46.000 2024-02-13 16:51:46.000 2024-02-13 17:01:46.000 2024-02-13 17:11:46.000 2024-02-13 17:21:46.000 2024-02-13 17:31:47.000 2024-02-13 17:41:47.000 2024-02-13 17:51:47.000 2024-02-13 18:01:47.000 2024-02-13 18:11:47.000 2024-02-13 18:21:47.000 2024-02-13 18:31:47.000 2024-02-13 18:41:47.000

[Anonymous]

Hi, @Radan 

Already viewed February data, but what is your expected output for February, the post only shows the expected output for January.

Best Regards,
Yang
Community Support Team