Appending 3 Excel Worksheets of Data together - Totals do not stack

[tylesftw]

Hi Guys

I have loaded 3 worksheets (that have the same column headers and structure), into my PBI model. I then have appended all three worksheets into a new table.

However, for some reason my totals do not represent the 3 worksheets put together - should be 900 not 600$revenues

Anybody had this issue before?

Thanks

Regards

Rob

[jortega8809]

assuming all columns headers are matching.. I would check the revenue data type.. sometimes it can import as data type text/numerical...

[mohittimpus]

Hii @tylesftw,

Can you please share file? 

[tylesftw]

Hi Mohittimpus, I cannot share the file as it has confidential data.