Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Inconsistent results when using Merge Queries

I'm having an issue where I get different results when I create a dataset with certain steps such as filtering out data and sorting, delete the steps, and recreate them again. Sometimes rows are left out and what I have in the Power Query screen doesn't match when I create a table in the report. I have had one line of data with an amount of 350 and if i create a table in the report and have it do a summation, it multiplies it by 2 and displays 700. This multiply by 2 happens randomly to other numbers in the same column as well. I have rows appear and disappear and the number multiplied by 2 go back to what it should be when the only change i do to a dataset is sort the dataset by date. Please advise!
Status: New
Comments
fbcideas_migusr
New Member
Status changed to: New