Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Adding a new dataset doubles the values

Hello everyone,

 

I've set up a PowerbI report based on data I receive monthly. I've created a Sharepoint folder which is where the data set is located.

I receive a monthly YTD file, which includes data from january 1st until the end of the month of the month I receive a new file. 
My goal is to upload the new YTD file to the same Sharepoint folder, so that the report includes the latest month of data. 

However, when I upload the new file, my values seem to double in PowerBI. 

 

This is before:

 

This is after:

 

It just seems to add the values in the new file, with the ones in the previous file, but I only want it to add the values of the latest month.

 

Any help would be greatly appreciated

2 Replies

  • Anonymous , if each file contains a YTD, then you need a replacement for the current year file in the folder. Is that happening or you have two YTD files for same year

    • Anonymous's avatar
      Anonymous
      Not applicable

      I have two YTD files for the same year. Is there a way to fix this? I wished that it would understand that the data from the previous file is identical and therefore not duplicate