Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
If possible please share a sample pbix file after removing sensitive information.
Thanks