Wrong total in time series aggregation - But just on some dates

[Anonymous]

Hi all,

Apologies if this has already been answered, I couldn't find any relevant thread.

I have a long time series of data at 15 min intervals, that I want to aggregate by day. The problem is that for some days, the result on PowerBI is wrong, as you can see comparing it with the same result obtained with a pivot table in excel.
See images attached:

As this is a very basic operation I really can't understand what has gone wrong here. Can anyone help me out with it?
Cheers

Marco

EDIT: drilling deeper in the data, I've noticed that the data from 29th Oct 17.30 to 30th Octo 17:15 is multiplied by 4, then it goes back to normal. Still no clue about the reason

[Anonymous · Accepted solution]

I've managed to understand what was wrong, and it was a problem in the source files. Some lines were repeated four times.

Sorry for the silly question.

[amitchandak]

 If possible please share a sample pbix file after removing sensitive information.
Thanks