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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |